I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00 for
example

Hi!

Try this:

=ROUND(A1/0.25,0)*0.25

Biff

"frumious" wrote in message
...
I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
for
example

Or
=ROUND(A1*4,0)/4

Cheers
--
macropod
[MVP - Microsoft Word]


"Biff" wrote in message
...
Hi!

Try this:

=ROUND(A1/0.25,0)*0.25

Biff

"frumious" wrote in message
...
I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
for
example

"frumious" wrote in message
...
I would like to be able round in quarter points. 4.25, 4.50, 4.75 or 5.00
for
example

=MROUND(A1,0.25)
--
David Biddulph

Hello,

=INT(F3*4+0.5)/4

if you do not like (or you do not know or you do not have) ROUND/MROUND
:-)

Regards,
Bernd