How do I tell a price list to round up and down to the nearest 25
I have created a price list in excel but the amounts are coming out at say
£25.68 and I would like to tell it to round up or down to the nearest 25p can I do this |
How do I tell a price list to round up and down to the nearest 25
Try...
=ROUND(25.68/0.25,0)*0.25 Hope this helps! In article , "Philippa" wrote: I have created a price list in excel but the amounts are coming out at say £25.68 and I would like to tell it to round up or down to the nearest 25p can I do this |
How do I tell a price list to round up and down to the nearest 25
=ROUND(A21*4,0)/4
where A21 holds the amount -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Philippa" wrote in message ... I have created a price list in excel but the amounts are coming out at say £25.68 and I would like to tell it to round up or down to the nearest 25p can I do this |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com