How can I round in quarter points?

[Guest]

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

 

[Biff]

Hi!

Try this:

=ROUND(A1/0.25,0)*0.25

Biff

 

[macropod]

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

Cheers

 

[David Biddulph]

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)

 

[bplumhoff]

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