Round up or down

[Guest]

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

 

[Peo Sjoblom]

That is correct, if you want 2072.92 you need to round down

=FLOOR(F10-G10,0.01)

 

[Guest]

Hi

Does this help?

=ROUNDDOWN(H10,2)

 

[Guest]

Never noticed FLOOR....learn something new everyday
--

_______________________
Naz,
London

That is correct, if you want 2072.92 you need to round down

=FLOOR(F10-G10,0.01)

 

[Guest]

I just put =ROUND((F10*0.005),2) in cell G10 and it looks like it works.

 

[David Biddulph]

It is rounding correctly.

The correct answer is 2072.92728, so if you round to the nearest hundredth
it would be 2072.93.
Why do you say it should be 2072.92? Have you done the arithmetic?
If you particularly want to round down, you can use =ROUNDOWN(H10,2).

 

[Peo Sjoblom]

It is more effective and easier to use, same goes for it's relative CEILING

--
Regards,

Peo Sjoblom

Never noticed FLOOR....learn something new everyday

 

[Guest]

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,