O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Functions for Complex Numbers

There are 18 functions total for complex numbers. At this point, this chapter gives you some basic explanations. The individual functions will refer to this passage.

In school, you learned that any number squared is positive:

22 = 4

(–2)2 = 4

This also means that it is not possible to take the square root of negative numbers:

image with no caption

In the four basic arithmetic calculations, there is an inversion for every operation: addition ↔ subtraction and multiplication ↔ division. Shouldn’t this be applicable to exponentiation ↔ extracting a root? Mathematicians could not stop thinking about this problem. They regarded the call for “completeness ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required