Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest 25 including negative numbers??
I have the following formula
=CEILING(Sheet4!BY6, 25) How I get it to round negative numbers too It works with positive numbers but when I insert ie -360, it should read -350 but I get the following #NUM! -- Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest 25 including negative numbers??
You need a little IF/THEN assistance:
=IF(Sheet4!BY60, CEILING(Sheet4!BY6,25), FLOOR(ABS(Sheet4!BY6),25)*-1) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Bob" wrote: I have the following formula =CEILING(Sheet4!BY6, 25) How I get it to round negative numbers too It works with positive numbers but when I insert ie -360, it should read -350 but I get the following #NUM! -- Bob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest 25 including negative numbers??
By the way, your thread title says "nearest 25" but you're example used
CEILING, which always rounds UP. So my first answer was in the same vein. But if you really want the numbers to round to the nearest 25, both up or down, then use this: =IF(G30,MROUND(G3,25),MROUND(ABS(G3),25)*-1) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Bob" wrote: I have the following formula =CEILING(Sheet4!BY6, 25) How I get it to round negative numbers too It works with positive numbers but when I insert ie -360, it should read -350 but I get the following #NUM! -- Bob |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest 25 including negative numbers??
On Sat, 9 May 2009 09:38:01 -0700, Bob wrote:
I have the following formula =CEILING(Sheet4!BY6, 25) How I get it to round negative numbers too It works with positive numbers but when I insert ie -360, it should read -350 but I get the following #NUM! =round(sheet4!BY6/25,0)*25 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding numbers to the nearest dollar amount | Excel Worksheet Functions | |||
Rounding formulas for negative numbers | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Ploting data with a large range including negative numbers | Charts and Charting in Excel | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) |