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