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