ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERFC.PRECISE is the 2010 version of ERFC.Syntax=ERFC.PRECISE(x)ArgumentWhat it meansxValueExamplesExample.
Read article →Engineering
Excel Engineering functions explained with syntax, examples and common mistakes.
GESTEP Function in Excel: Is It at Least the Threshold?
GESTEP Function in Excel: Is It at Least the Threshold?
GESTEP returns 1 if a number is greater than or equal to a step value, otherwise 0 — SUM it to count values over…
Read article →ERFC Function in Excel: Complementary Error Function
ERFC Function in Excel: Complementary Error Function
EngineeringLevel: ExpertAvailable in: Excel 2007+ERFC returns 1 - ERF(x): the tail beyond x.Syntax=ERFC(x)ArgumentWhat it meansxValueExamplesExample.
Read article →IMCSC Function in Excel: Cosecant of a Complex Number
IMCSC Function in Excel: Cosecant of a Complex Number
IMCSC returns 1/sin(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →ERF Function in Excel: Error Function
ERF Function in Excel: Error Function
ERF returns the error function between 0 and x (or between two limits), used in probability and diffusion.
Read article →IMARGUMENT Function in Excel: Angle of a Complex Number
IMARGUMENT Function in Excel: Angle of a Complex Number
IMARGUMENT returns the angle θ in radians (phase angle). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →DELTA Function in Excel: Are Two Numbers Equal?
DELTA Function in Excel: Are Two Numbers Equal?
DELTA returns 1 if two numbers are equal and 0 otherwise — easy to SUM for a count of matches.
Read article →IMDIV Function in Excel: Divide Complex Numbers
IMDIV Function in Excel: Divide Complex Numbers
IMDIV divides one complex number by another, e.g. current = voltage / impedance.
Read article →IMCOS Function in Excel: Cosine of a Complex Number
IMCOS Function in Excel: Cosine of a Complex Number
IMCOS returns cos(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMREAL Function in Excel: Real Part
IMREAL Function in Excel: Real Part
IMREAL returns the real coefficient a of a+bi. Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMCONJUGATE Function in Excel: Complex Conjugate
IMCONJUGATE Function in Excel: Complex Conjugate
IMCONJUGATE returns a-bi. Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSINH Function in Excel: Hyperbolic Sine of a Complex Number
IMSINH Function in Excel: Hyperbolic Sine of a Complex Number
IMSINH returns sinh(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →