# 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.

Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.