IMAGINARY Function in Excel: Imaginary Part
Extract the imaginary coefficient b from a complex number formatted as text (a+bi or a+bj) as a numeric value.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
REGEXREPLACE Function in Excel: Find and Replace With Patterns
REGEXREPLACE Function in Excel: Find and Replace With Patterns
REGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask numbers.
Read article →IMSQRT Function in Excel: Square Root of a Complex Number
IMSQRT Function in Excel: Square Root of a Complex Number
IMSQRT returns the principal square root. Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSUB Function in Excel: Subtract Complex Numbers
IMSUB Function in Excel: Subtract Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMSUB subtracts one complex number from another.Syntax=IMSUB(inumber1, inumber2)ArgumentWhat it.
Read article →IMSEC Function in Excel: Secant of a Complex Number
IMSEC Function in Excel: Secant of a Complex Number
IMSEC returns 1/cos(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMLOG2 Function in Excel: Base-2 Log of a Complex Number
IMLOG2 Function in Excel: Base-2 Log of a Complex Number
IMLOG2 returns log2(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →Automatic Serial Numbers in Excel That Survive Filtering, Deleting and Blanks
Automatic Serial Numbers in Excel That Survive Filtering, Deleting and Blanks
Number rows 1, 2, 3 automatically: ROW and SEQUENCE for clean lists, COUNTA to skip blank rows, SUBTOTAL/AGGREGATE so numbering stays 1-2-3 after filtering,…
Read article →IMPOWER Function in Excel: Complex Number to a Power
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 →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 →