Excel® 2013 On Demand

Using Math Functions

You can use math & trigonometry functions to help you perform mathematical calculations. You can use formulas for calculations, such as SQRT (Square root) or TAN (Tangent); formulas for conversion, such as DEGREES (radians to Degrees), or RADIANS (degrees to Radians); or formulas for rounding, such as FLOOR (number down, toward zero), CEILING (number up, towards nearest integer), INT (number down to nearest integer), or ROUND (number to a specific number of digits). You can also use the RAND function to generate random real numbers between 0 and 1, which you can use in an equation to create other random numbers, such as =RAND()*100—creates random numbers between 0 and 100. Many of the math functions use the following arguments: ...