Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need help in coming up with a formula to apply rounding depending on the
value ranges as follows: xx.00 - do not apply round formula xx.01 to xx.25, then round to xx.25 xx.26 to xx.50, then round to xx.50 xx.51 to xx.75, then round to xx.75 xx.76 to xx.99, then add +1 to xx. For example, if 33.23, the result should be 33.25; if 33.72, the result should be 33.75; if 33.94, then the result should be 34.00. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
Rounding up results to meet minimum order quantities. | Excel Worksheet Functions | |||
How do I do a VLOOKUP from 2 ranges and add the results together? | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |