#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Naz Naz is offline
external usenet poster
 
Posts: 85
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Naz Naz is offline
external usenet poster
 
Posts: 85
Default 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




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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






  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
round down? dbrumit Excel Discussion (Misc queries) 1 February 15th 07 05:35 PM
@ROUND steph44haf Excel Worksheet Functions 4 October 23rd 06 02:06 PM
Round up rexmann Excel Discussion (Misc queries) 7 April 13th 06 01:48 PM
VBA round Jeff Excel Discussion (Misc queries) 8 September 2nd 05 02:38 AM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 11:50 AM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"