| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a formula total to quit rounding up in Excel?
I have a formula in a cell =PRODUCT(H17*A31, 4) and the answer should be
$67.96 but it's coming up $68.00. If I change the number of decimal places, it only changes the answer is $68.000; I've changed the size of the column and that doesn't help either. Thanks for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't quit excel | Excel Discussion (Misc queries) | |||
| Why is a row's total rounding up? | Excel Worksheet Functions | |||
| Excel won't quit | Excel Discussion (Misc queries) | |||
| Rounding percentage's of the total | Excel Discussion (Misc queries) | |||
| Excel Quit opening | Excel Discussion (Misc queries) | |||
Threaded Mode
