Excel All Mathematics Functions With Full Description : Part 2

11: Sqrt

Sqrt (number)

Use :- return the square root of the specified number

Example :- sqrt(49)

12: Product

Product (number1, number2, number3,……..)

Use :- use multiplies all the number given as argument

Example :- product(5,10,5)

13: Power

Power (number, power)

Use :- return the result of a number raised to a power

Example :- power(5,3)

14: Round

Round (number, number_digit)

Use :- round a number to a specify number of digit

Example :- round (1234.263,2)

15: Roman

Roman (number, [form])

Use :- convert the specified number into roman digit

Example :- roman(125)

16: Celling

Celling (number, significance)

Use :- round a number up to the nearest integer or to the nearest of multiplies of significance

Example :- celling (65,3)

17: Floor

Floor (number, significance)

Use :- rounds a number down to the nearest integer or to the nearest of maltiply of  significance

Example :- floor(65,3)

18: Mod

Mod :- (number , divisor)

Use :- return the remainder after a number is divided by a divisor

Example :- (35,3)

19: pi

Use :- return the value of PI

Example :- pi ()

20: Sum if

Sum if (range, critearia, sum _ range)

Use :- adds the cells specified by a given condition or critearia

 example :- sum if(c2:d5,”<=25”)