IMPOWER Function in Excel: Complex Number to a Power
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMPOWER raises a complex number to a power.Syntax=IMPOWER(inumber, number)ArgumentWhat it.
Read article →Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
IMTAN Function in Excel: Tangent of a Complex Number
IMTAN Function in Excel: Tangent of a Complex Number
IMTAN returns tan(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSUM Function in Excel: Add Complex Numbers
IMSUM Function in Excel: Add Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMSUM adds complex numbers: (3+4i)+(1-i) = 4+3i. Impedances in series add.Syntax=IMSUM(inumber1.
Read article →ISOMITTED Function in Excel: Was an Optional Argument Left Out?
ISOMITTED Function in Excel: Was an Optional Argument Left Out?
LogicalLevel: ExpertAvailable in: Excel 365 / 2021+ISOMITTED is used inside LAMBDA to give optional parameters default.
Read article →T Function in Excel: Keep Text, Blank Out Numbers
T Function in Excel: Keep Text, Blank Out Numbers
T returns text unchanged and anything else as an empty string. Rarely needed alone, but tidy for mixed columns.
Read article →N Function in Excel: Turn a Value Into a Number
N Function in Excel: Turn a Value Into a Number
N returns numbers unchanged, TRUE as 1 and text as 0. Its oddest use is hiding a note inside a formula.
Read article →DVAR Function in Excel: Sample Variance of Matching Records
DVAR Function in Excel: Sample Variance of Matching Records
DVAR returns the sample variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS returns |z|, the length of the vector: SQRT(a²+b²). For impedance it's the magnitude in ohms. Complex numbers are text like 3+4i; build them…
Read article →DCOUNTA Function in Excel: Count Non-Empty Records Matching Criteria
DCOUNTA Function in Excel: Count Non-Empty Records Matching Criteria
DCOUNTA counts non-blank entries in a field for records that meet the criteria; unlike DCOUNT it also counts text. Like all D-functions it uses…
Read article →EUROCONVERT Function in Excel: Convert Between Euro and Old Euro-Zone Currencies
EUROCONVERT Function in Excel: Convert Between Euro and Old Euro-Zone Currencies
EUROCONVERT converts between the euro and former national currencies (DEM, FRF, ITL …) at the fixed 1999-2002 rates. It needs the Euro Currency Tools…
Read article →DVARP Function in Excel: Population Variance of Matching Records
DVARP Function in Excel: Population Variance of Matching Records
DVARP returns the population variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →TOROW Function in Excel: Flatten Into One Row
TOROW Function in Excel: Flatten Into One Row
TOROW flattens a block into a single row, optionally skipping blanks and errors.
Read article →