Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding results by ranges
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding results by ranges
Try =CEILING(A1,0.25)
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mmarley50" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding results by ranges
If you really mean round, so xx.12 rounds to xx.00:
=mround(A1,.25) But if you mean round up, so xx.12 becomes xx.25: =CEILING(A1,.25) -- Kind regards, Niek Otten Microsoft MVP - Excel "mmarley50" wrote in message ... |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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding results by ranges
I should have added:
From Excel Help: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | If you really mean round, so xx.12 rounds to xx.00: | =mround(A1,.25) | But if you mean round up, so xx.12 becomes xx.25: | =CEILING(A1,.25) | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "mmarley50" wrote in message ... ||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. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |