| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I write a formula to round up a number?
I want to write a formula that will allow me to multiply a currency number by
9 and then round the number up so that it ends in 9. For example, $56.50 x 9 = $508.50 and then round it up to be $509 (no decimals needed). Thanks so much for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Discussion (Misc queries) | |||
| Using formula to calculate a number. | Excel Worksheet Functions | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
