use of round in a formula

[shamsu203]

HI
I want to round the result of a formula in excel .the attached worksheet shows the result of the calculation and also the result required on rounding .

 

[SanjayGMusafir]

.the attached worksheet shows the result of the calculation and also the result required on rounding

???

Share the formula and required result in the thread itself...

 

[kvsrinivasamurthy]

Try
=Your formula&" rounded value is "&Round(Your formula,0)

 

[awoohaw]

Here are some cell formula examples in an xl2bb mini sheet:

Mr Excel Questions 73.xlsm
	A	B
1
2	2
3	3
4	0.666666667	=A2/A3
5	0.6667	=ROUND(A4,4)
6	0.667	=ROUND(A2/A3,3)
Sheet2

Cell Formulas
Range	Formula
A4	A4	=A2/A3
B4:B6	B4	=FORMULATEXT(A4)
A5	A5	=ROUND(A4,4)
A6	A6	=ROUND(A2/A3,3)