| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding Formula
You gave a limited example, but if you want to get to the nearest 10 cents:
? application.Round(1.17,1) 1.2 so =round(D28/L3+L35,1) and format the cell for two decimal places. -- Regards, Tom Ogilvy "Chev320" wrote: I know this is a simple one for you guys, but i just cant see it.. My dollar amount equals $1.17 and i want to round up to 1.20. I have tried Ceiling & round & roundup with no luck.. =D28/L3+L35 (this is my formula so far) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
| formula for rounding | Excel Programming | |||
Threaded Mode
