Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding Up & Down
What is the easiest way to be able to round, as normal, except to round down
if the answer is .5, 1.5, 2.5 etc? So for example, if I want to take 90% and 10% of 5, using the normal ROUND function I would get 5 and 1 for a total of 6 which is greater than the whole. To fix this I'd like to have one of the formulas round down if the answer ends in .5 (but not .6, for example). Thoughts? Thanks for the help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding Up & Down
use = roundup(cell*.9,0) use rounddown(cell*.1,0) or use round(cell,0)
the 0 after the , tells it to round to no decimal places -- BerbatovIsGod "Cheesus171" wrote: What is the easiest way to be able to round, as normal, except to round down if the answer is .5, 1.5, 2.5 etc? So for example, if I want to take 90% and 10% of 5, using the normal ROUND function I would get 5 and 1 for a total of 6 which is greater than the whole. To fix this I'd like to have one of the formulas round down if the answer ends in .5 (but not .6, for example). Thoughts? Thanks for the help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding Up & Down
Subtract 0.01 from the initial number. Now it's 1.49 instead of 1.5 and will
round down. HTH. Best wishes Harald "Cheesus171" wrote in message ... What is the easiest way to be able to round, as normal, except to round down if the answer is .5, 1.5, 2.5 etc? So for example, if I want to take 90% and 10% of 5, using the normal ROUND function I would get 5 and 1 for a total of 6 which is greater than the whole. To fix this I'd like to have one of the formulas round down if the answer ends in .5 (but not .6, for example). Thoughts? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding | Excel Worksheet Functions | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
rounding | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Worksheet rounding vs VBA rounding | Excel Programming |