View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Round down to nearest 5p

With value in A1

=INT(A1/0.05)*0.05

"Meltad" wrote:

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 :-)