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. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com