Thread: ROUNDING
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default ROUNDING
Hi Bill

Try
=FLOOR(A1,0.25)

to round up
=CEILING(A1,0.25)

--
Regards

Roger Govier


"Bill Ridgeway" wrote in message
...
How do you round down to the nearest £0.25 please

Thanks.

Bill Ridgeway



Reply With QuoteReply With Quote