Round up or down
 

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

Round up or down
 

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

Round up or down
 

Hi

Does this help?

=ROUNDDOWN(H10,2)
--

_______________________
Naz,
London


"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

Round up or down
 

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

Round up or down
 

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


"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

Round up or down
 

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).
--
David Biddulph

"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

Round up or down
 

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

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