ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I tell a price list to round up and down to the nearest 25 (https://www.excelbanter.com/excel-worksheet-functions/64720-how-do-i-tell-price-list-round-up-down-nearest-25-a.html)

Philippa January 12th 06 12:00 PM

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

Domenic January 12th 06 12:44 PM

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


Bob Phillips January 12th 06 12:57 PM

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 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com