Round down to nearest 5p

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 :-)
 
=FLOOR(A1,.05)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Isn't that down to the half-penny, not 5p?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top