| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :-) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 :-) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round down to nearest 5p
If your number is in A1, try this:
=FLOOR(A1,0.05) Hope this helps. Pete 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 :-) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round down to nearest 5p
=FLOOR(A1,.05)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Meltad" wrote in message ... 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 :-) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round down to nearest 5p
Brill - I used =FLOOR((D23+2),0.005) in the end.
Thanks all "Bob Phillips" wrote: =FLOOR(A1,.05) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Meltad" wrote in message ... 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 :-) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round down to nearest 5p
Isn't that down to the half-penny, not 5p?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Meltad" wrote in message ... Brill - I used =FLOOR((D23+2),0.005) in the end. Thanks all "Bob Phillips" wrote: =FLOOR(A1,.05) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Meltad" wrote in message ... 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 :-) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round down to nearest 5p
..005 is half a pence, not five pence.
..05 is five pence. Dave -- Brevity is the soul of wit. "Meltad" wrote: Brill - I used =FLOOR((D23+2),0.005) in the end. Thanks all "Bob Phillips" wrote: =FLOOR(A1,.05) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Meltad" wrote in message ... 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 :-) |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round down to nearest 5p
My mistake, just a typo, I did use 0.05!!
Thanks "Dave F" wrote: .005 is half a pence, not five pence. .05 is five pence. Dave -- Brevity is the soul of wit. "Meltad" wrote: Brill - I used =FLOOR((D23+2),0.005) in the end. Thanks all "Bob Phillips" wrote: =FLOOR(A1,.05) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Meltad" wrote in message ... 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 :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Round to Nearest Thousand | Excel Discussion (Misc queries) | |||
| Round to nearest thousand | Excel Discussion (Misc queries) | |||
| i need an excell formula that will round up to the nearest 9.99 | Excel Worksheet Functions | |||
| Round Up to Nearest 10 | Excel Worksheet Functions | |||
| Round time to nearest quarter hr | Excel Worksheet Functions | |||
Linear Mode
