how do I round 3.30 to the nearest quarter. 3.30=3.25

[Bob Phillips]

=ROUND(A1*4,0)/4

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[via135]

=MROUND(3.3,0.25)

-via135