Or even:
=CEILING(A1,0.25)
(for an alternative for the =roundup() sample)
CLR wrote:
Another........
=MROUND(A1,0.25)
or if you're doing pricing you may want
=ROUNDUP(A1*4,0)/4
Vaya con Dios,
Chuck, CABGx3
"JE McGimpsey" wrote in message
...
One way:
=ROUND(A1*4,0)/4
In article ,
LeelooIvy wrote:
How do you round numbers to the nearest quarter?
--
Dave Peterson
|