| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding down to positive when adding cells
When I am adding two cells excel wants to round down to a positive number. I
have tried to use the accounting and the currency function with no success. Example would be =C5 ($23.81) + E5 (23.82) I get $47.62 not $47.63 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells witht the same name | Excel Discussion (Misc queries) | |||
| Adding up multiple cells | Excel Worksheet Functions | |||
| Adding cells with the same color, sub works but function doesnt | Excel Discussion (Misc queries) | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) | |||
Threaded Mode
