ExcelBanter - How do i round up a price to the nearest 5,10,15 etc pence

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do i round up a price to the nearest 5,10,15 etc pence (https://www.excelbanter.com/excel-worksheet-functions/26692-how-do-i-round-up-price-nearest-5-10-15-etc-pence.html)

Millsy

How do i round up a price to the nearest 5,10,15 etc pence

Looking for a formula in which i can use to round up prices to the nearest
5,10 pence etc as i have thousands of prices which need to be rounded up to
the nearest 5 pence, and need sum/formula which i can use. Please help and
advise if you can.

Kindest Regards

Check the help for the ceiling function. It will probably do what you want.

"Millsy" wrote:

Looking for a formula in which i can use to round up prices to the nearest
5,10 pence etc as i have thousands of prices which need to be rounded up to
the nearest 5 pence, and need sum/formula which i can use. Please help and
advise if you can.

Kindest Regards

All times are GMT +1. The time now is 10:13 AM.