| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to enter to round an Excel value up to the next $0.5?
If I have a value of $10 and add 10% by dividing by 0.90, I get $11.11 which
I would like to round up to the nearest $0.5, i.e. $11.15. Does anybody know the formula and can you use it on a result which is also a formula? Thanks, Lee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to enter to round an Excel value up to the next $0.5?
"Lee" wrote:
If I have a value of $10 and add 10% by dividing by 0.90, I get $11.11 which I would like to round up to the nearest $0.5, i.e. $11.15. From your example, I presume you mean "nearest $0.05" (nickel). Does anybody know the formula and can you use it on a result which is also a formula? If you truly mean "round up", as your example might suggest: =CEILING(A1, 0.05) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula for < or numbers. | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| excel array formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Linear Mode
