The following functions are available to manipulate complex numbers. In all cases, c represents a complex number. Note that there is an example of each complex function in the PipeDream Examples archive.
PipeDream uses 1 by 2 arrays to represent complex numbers.
The formula C_ADD({1,2},{3,4})
would return the result
{4,6}
.
Because ranges can be used instead of arrays, you could enter 1
in cell A1 and 2
in cell B1 then use
C_ADD(A1B1,{3,4})
.
If you enter the formula {A1,B1}
in cell A2, you could use
C_ADD(A2,{3,4})
.
Each of these would produce the same result.
C_ACOS(c)
Returns the complex arc cosine of c as a complex number.
C_ACOSEC(c)
Returns the complex arc cosecant of c as a complex number.
C_ACOSECH(c)
Returns the complex hyperbolic arc cosecant of c as a complex number.
C_ACOSH(c)
Returns the complex hyperbolic arc cosine of c as a complex number
C_ACOT(c)
Returns the complex arc cotangent of c as a complex number.
C_ACOTH(c)
Returns the complex hyperbolic arc cotangent of c as a complex number.
C_ADD(c1, c2)
Returns the sum of c1 and c2 as a complex number.
C_ASEC(c)
Returns the complex arc secant of c as a complex number.
C_ASECH(c)
Returns the complex hyperbolic arc secant of c as a complex number
C_ASIN(c)
Returns the complex arc sine of c as a complex number.
C_ASINH(c)
Returns the complex hyperbolic arc sine of c as a complex number.
C_ATAN(c)
Returns the complex arc tangent of c as a complex number.
C_ATANH(c)
Returns the complex hyperbolic arc tangent of c as a complex number
C_COS(c)
Returns the complex cosine of c as a complex number.
C_COSEC(c)
Returns the complex cosecant of c as a complex number.
C_COSECH(c)
Returns the complex hyperbolic cosecant of c as a complex number.
C_COSH(c)
Returns the complex hyperbolic cosine of c as a complex number.
C_COT(c)
Returns the complex cotangent of c as a complex number.
C_COTH(c)
Returns the complex hyperbolic cotangent of c as a complex number.
C_DIV(c1, c2)
Returns the result of dividing c1 by c2 as a complex number.
C_EXP(c)
Returns e to the power of c as a complex number.
C_LN(c)
Returns the natural logarithm of c as a complex number.
C_MUL(c1, c2)
Returns the result of multiplying c1 by c2 as a complex number.
C_POWER(c1, c2)
Returns the result of raising c1 to the power of c2 as a complex number.
C_RADIUS(c)
Returns the modulus of c as a real number.
C_SEC(c)
Returns the complex secant of c as a complex number.
C_SECH(c)
Returns the complex hyperbolic secant of c as a complex number.
C_SIN(c)
Returns the sine of c as a complex number.
C_SINH(c)
Returns the hyperbolic sine of c as a complex number.
C_SUB(c1, c2)
Returns the result of subtracting c2 from c1 as a complex number
C_TAN(c)
Returns the tangent of c as a complex number.
C_TANH(c)
Returns the hyperbolic tangent of c as a complex number.
C_THETA(c)
Returns the parameter in radians of c.
This function is similar to ATAN_2.