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.

 

© 2016 - 2022, All Rights are Reserved.