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

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

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

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

"EM" wrote:

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

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

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



--
Regards,

Peo Sjoblom



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

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

"Peo Sjoblom" wrote...
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

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

"Harlan Grove" wrote in message
ups.com...
"Peo Sjoblom" wrote...
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


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