Thread: How do I tell a price list to round up and down to the nearest 25
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default How do I tell a price list to round up and down to the nearest 25
Try...

=ROUND(25.68/0.25,0)*0.25

Hope this helps!

In article ,
"Philippa" wrote:

I have created a price list in excel but the amounts are coming out at say
£25.68 and I would like to tell it to round up or down to the nearest 25p can
I do this
Reply With QuoteReply With Quote