Excel Math Functions

FUNCTIONSYNTAX
ABSABS(number)
ARABICARABIC( text )
ASINASIN(number)
CEILINGCEILING(number,significance)
CEILING.MATHCEILING.MATH(number, [significance], [mode])
CEILING.PRECISECEILING.PRECISE(number, [significance])
COSCOS(number)
DECIMALDECIMAL(text, radix)
DEGREESDEGREES(angle)
EVENEVEN(number)
EXPEXP(number)
FACTFACT(number)
FLOORFLOOR(number,significance)
FLOOR.MATHFLOOR.MATH(number, significance, mode)
FLOOR.PRECISEFLOOR.PRECISE(number, [significance])
GCDGCD(number1,number2, ...)
INTINT(number)
LCMLCM(number1,number2, ...)
LNLN(number)
LOGLOG(number,base)
LOG10LOG10(number)
MODMOD(number,divisor)
MROUNDMROUND(number,multiple)
ODDODD(number)
PIPI( )
POWERPOWER(number,power)
QUOTIENTQUOTIENT(numerator,denominator)
RADIANSRADIANS(angle)
RANDRAND( )
RANDBETWEENRANDBETWEEN(bottom,top)
ROMANROMAN(number,form)
ROUNDROUND(number,num_digits)
ROUNDDOWNROUNDDOWN(number,num_digits)
ROUNDUPROUNDUP(number,num_digits)
SIGNSIGN(number)
SINSIN(number)
SQRTSQRT(number)
SUBTOTALSUBTOTAL(function_num, ref1, ref2, ...)
SUMSUM(number1,number2, ...)
SUMIFSUMIF(range,criteria,sum_range)
SUMIFSSUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2…)
SUMPRODUCTSUMPRODUCT(array1,array2,array3, ...)
TANTAN(number)
TRUNCTRUNC(number,num_digits)