×

# MS Excel Math Functions

 Function Name Description Example ABS(number) Return position number of given number ceiling(number) Round up to the nearest integer, ex =ceiling(number, 1) sin(number) Return sine of a number cos(number) Return cosine of a number tan(number) Return tangent of a number degrees(angles) Convert radian into degree radians(angles) Convert degree into radian exp(number) Return exponential of a number fact(number) Return factorial of a number floor(number) Return round down of a number to the nearest integer gcd(number1, number2) Return the greatest common divisior lcm(number1, number) Return least common multiple mod(number, divisor) Return the remainder in division pi() Return pi value power(number, power) Return power of a given number product(number1, number2) Return the multiplication of all the given numbers quotient(numerator, denominator) Return quotient in division rand() Return random number between 0 and 1 randbetween(bottom, top) Return random number between bottom and top roman(number, form) Return roman number of given number round(number, num_digt) Round the number to nearest given digits. sqrt(number) Return square root of a given number.