| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round numbers to the nearest quarter? | Excel Worksheet Functions | |||
| 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 | |||
| I am trying to round up to the nearest 25 cents | New Users to Excel | |||
| Round time to nearest quarter hr | Excel Worksheet Functions | |||
Linear Mode
