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

--
Regards,

Peo Sjoblom


"Naz" wrote in message
...
Never noticed FLOOR....learn something new everyday
--

_______________________
Naz,
London


"Peo Sjoblom" wrote:

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

=FLOOR(F10-G10,0.01)

--
Regards,

Peo Sjoblom

"cybergardener" wrote in
message
...
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