Round up or down
Hi,
If you put all your formulas in the ROUND function with 2 decimal rounding
then you can reach to 2072.92 like below:
E10 52083.60
F10 =ROUND(E10*0.04,2)
G10 =ROUND(F10*0.005,2)
H10 =ROUND(F10-G10,2)
thanks,
--
Farhad Hodjat
"cybergardener" wrote:
I can't get a number to round correctly. H10 should be 2072.92 but my
formula comes up as 2072.93. Can you please help me with this senario? This
is what I have in the following cells.
E10 52083.60
F10 =E10*0.04
G10 =F10*0.005
H10 =F10-G10
--
Thanks
Cyber Gardener
|