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

E

EM

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

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
 
P

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
 
H

Harlan Grove

Peo Sjoblom said:
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
Click to expand...
....

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
 
P

Peo Sjoblom

Harlan Grove said:
...

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
Click to expand...


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
 
Top