ROUND(number,num_digits) rounds a number to a specified number of digits : ROUND « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =ROUND(2.15, 1)
Input the formula: =ROUND(2.15, 1)
20.40.ROUND
20.40.1.ROUND(number,num_digits) rounds a number to a specified number of digitsROUND(number,num_digits) rounds a number to a specified number of digits
20.40.2.=ROUND(2.149, 1)=ROUND(2.149, 1)
20.40.3.=ROUND(-1.475, 2)=ROUND(-1.475, 2)
20.40.4.=ROUND(21.5, -1)=ROUND(21.5, -1)