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.

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.

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.

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.
|
|