| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Formulas
I'm having a problem in rounding up the following formula to the nearest
cent. Also, I have several of these formulas in a column, when the column is totaled it uses the full formula extension not the value shown in the cell and it makes the total not reflect the values in the cells. How can I correct these problems? =SUM(B1*3.3%) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to minimize rounding error with complicated formulas | Excel Discussion (Misc queries) | |||
| formulas / rounding | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| rounding a formula's number | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
