View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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