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

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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top