| 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. |
|
#2
|
|||
|
|||
|
Try:
=ROUNDUP(A1*9+1,-1)-1 HTH Jason Atlanta, GA -----Original Message----- 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. . |
|
#3
|
|||
|
|||
|
"Jason Morin" wrote: Try: =ROUNDUP(A1*9+1,-1)-1 HTH Jason Atlanta, GA -----Original Message----- 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. . |
|
#4
|
|||
|
|||
|
Hi Jason, Works great... You rock! You have saved us so much time and eliminated a lot of angst. Barbie & Andrea "Jason Morin" wrote: Try: =ROUNDUP(A1*9+1,-1)-1 HTH Jason Atlanta, GA -----Original Message----- 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. . |
| Reply |
| 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 | |||
Hybrid Mode
