Round down to nearest 5p

[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

 

[Guest]

With value in A1

=INT(A1/0.05)*0.05

 

[Pete_UK]

If your number is in A1, try this:

=FLOOR(A1,0.05)

Hope this helps.

Pete

 

[Bob Phillips]

=FLOOR(A1,.05)

--
HTH

Bob Phillips

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

 

[Guest]

Brill - I used =FLOOR((D23+2),0.005) in the end.
Thanks all

 

[Bob Phillips]

Isn't that down to the half-penny, not 5p?

--
HTH

Bob Phillips

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

 

[Guest]

..005 is half a pence, not five pence.

..05 is five pence.

Dave

 

[Guest]

My mistake, just a typo, I did use 0.05!!
Thanks

.005 is half a pence, not five pence.

.05 is five pence.

Dave