| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round down? | Excel Discussion (Misc queries) | |||
| @ROUND | Excel Worksheet Functions | |||
| Round up | Excel Discussion (Misc queries) | |||
| VBA round | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
