ABS(): ABS( Profit ) : Absolute value

CEILING(): CEILING( Discount, 1 ) : Round up to multiple

FLOOR(): FLOOR( Discount ) : Round down

ROUND(): ROUND( Sales, 2 ) : Round to decimals

TRUNC(): TRUNC( Price, 0 ) : Truncate without rounding

INT(): INT( Revenue ) : Return integer part

POWER(): POWER( Sales, 2 ) : Exponentiation

SQRT(): SQRT( Variance ) : Square root

LN(): LN( Sales ) : Natural logarithm

EXP(): EXP( 1 ) : Euler's constant e^x

MOD(): MOD( Index, 2 ) : Modulo operation

QUOTIENT(): QUOTIENT( Quantity, 12 ) : Integer division result

RAND(): RAND() : Random number 0-1

RANDBETWEEN(): RANDBETWEEN(1,100) : Random integer

SIGN(): SIGN( Profit ) : Return sign of number
Previous Next