How can you round numbers to the nearest quarter (i.e. .63=>.75)

[EM]

there used to be an MROUND function that did this but I don't think excel has
it anymore. Any suggestions?

 

[Elkar]

MROUND does still exist, but it is part of the Analysis ToolPak, so that must
be installed for it to work.

In Excel 2003 or earlier:
TOOLS-->OPTIONS-->ADD-INS-->Check "Analysis ToolPak"

In Excel 2007:
OFFICE Button-->Excel Options-->Add-Ins-->GO Button-->Check "Analysis ToolPak"

Also, you may want to take a look at the CEILING and FLOOR functions.

HTH,
Elkar

 

[Peo Sjoblom]

It's still there, however there are other ways, assume A1 holds the value
you want to round

=ROUND(A1/25,0)*25

will do what you want

 

[Harlan Grove]

It's still there, however there are other ways, assume A1 holds
the value you want to round

=ROUND(A1/25,0)*25

will do what you want

....

It would if you had remembered the decimal points. Your formula rounds
to integer multiples of 25. To round to integer multiples of 0.25, use

=ROUND(A1/0.25,0)*0.25

or simplify the arithmetic

=ROUND(A1*4,0)/4

 

[Peo Sjoblom]

...

It would if you had remembered the decimal points. Your formula rounds
to integer multiples of 25. To round to integer multiples of 0.25, use

=ROUND(A1/0.25,0)*0.25

or simplify the arithmetic

=ROUND(A1*4,0)/4

I would have remembered if I had seen them, I just glanced at the subject
line and didn't see they were decimals. I see it now that you mentioned it.


Peo