Skip to content

Formulas Part 1

IS*() ?

=ISTEXT()
=ISNUMBER()
=ISDATE()
=ISLOGICAL()
=ISURL()
=ISFORMULA()
=ISBLANK()

Coversion

=N()
=TO_PERCENT()

=CONVERT(A2, "sec", "min")

Logarthmic Transformations

=LOG10()
=LN()

Exponential transformations

=EXP()
=POW(2,CELL)

Square and square root transformations

=SQRT()

Min and Max

=MIN(Range)
=MAX(Range)

Mean and Median

=SUM(Range)
=AVERAGE(Range)
=MEDIAN(Range)