| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula help! Removing a neg# & #DIV/0!
D28 is entered daily & cell has no formula E28 is =D28-D27 (copied down page) F28 is =E28/D28 (copied down page) Day total Day increase Percentage ----------+---------------+------------- (D28) (E28) (F28) 1215.02 6.74 0.005547234 ----------+---------------+------------- (D29) (E29) (F29) 1231 15.98 0.012981316 ----------+---------------+------------- D29 is entered daily & cell has no formula E29 is D29-D28 (copied down page) F29 is E29/D29 (copied down page) But in the next line & lines before I enter a # in the D colum cell I get this... I need to keep the formula and remove the data shown and from being totaled in E columb... can this be done? (D30) (E30) (F30) -1231 #DIV/0! D30 is to entered the next day but I need to total the E columb without the Negitive # in the cell... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Cell Without Removing Formula | Excel Worksheet Functions | |||
| keep number when removing formula | Excel Discussion (Misc queries) | |||
| Removing formulas but keeping formula totals. | Excel Discussion (Misc queries) | |||
| What Excel Formula = finding dup records and removing them? | Excel Worksheet Functions | |||
| Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
Threaded Mode
