     # ROUND

## “ROUND”

Used for – “ROUND” Function in MS Excel is used tell MS excel that a excel has to Round off the fraction value either typed or calculated with a formula upto specific digits after decimal and display the end result achieved.

Syntax – ROUND(Number, Num_Digits).

Example – Let us we have a fraction 1.546202 written in cell A1 and wants excel reads it upto two digits after decimal by rounding up and for one calculation and upto 1 digit after decimal for other calculation after rounding up then you can write up the formula as =ROUND(A1,2) in cell B1 and =ROUND(A1,1) in cell C1 you see the excel reads as you wish and also take same values which it shows for calculation. See example below:-
 A B C D E F G H I 1 1.546202 =ROUND(A1,2) =ROUND(A1,2) 2 =A1*2 =B1*2 =C1*2 3 4 5 6 7

And result you get as under:-
 A B C D E F G H I 1 1.526202 1.53 1.5 2 3.052404 3.06 3 3 4 5 6 7

You can check it yourself by copy the highlighted table and pasting in the first cell of the spread sheet.