Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOD and Ceiling formula used to round up and down to 49 and 99
Someone name Bob Phillips created this formula for me to have my numbers end
in either a 5 or a 9 and it works great. =CEILING(A10,5)-(AND(MOD(A10,10)<0,MOD(CEILING(A10,5),10)=0)) Can this formula be altered to end in either 49 or 99, depending on where the numbers fall. Example 4419 rounded down to 3999, 3329 rounded down to 3299 or 3339 rounded up to 3349, 3359 rounded up to 3399. I guess if the numbers were from 1-28 it could round down to 99. If its 29-48 round up to 49. If 50 to 59 then round down to 49 and if its 65 and up round up to 99. Any assistance I can get with this would be great. Thank you. -- Angie33 "Bob Phillips" wrote: =CEILING(A10,5)-(AND(MOD(A10,10)<0,MOD(CEILING(A10,5),10)=0)) -- Angie33 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
ceiling | Excel Discussion (Misc queries) | |||
how to use the ceiling function | Excel Worksheet Functions | |||
Round/Ceiling on an IF function returning numerical value or text | Excel Worksheet Functions | |||
Max, Ceiling, If, Etc | Excel Discussion (Misc queries) |