View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meltad Meltad is offline
external usenet poster
 
Posts: 98
Default Round down to nearest 5p

Hi,

I've searched the discussions for my answer but am now confused with several
slightly different ways...

I have a final selling price for a quote... then the quote to send out to
the customer has an extra £2 added on...
This quote figure needs to be rounded down to the nearest 5p... Whats the
easiset way???

Thanks, Mel :-)