Need formula help! Removing a neg# & #DIV/0!
You can structure the formulas to "behave" until valid data has been entered:
Instead of:
=D30-D29
in E30, use:
=IF(D30="","",D30-D29)
Instead of
=E30/D30
in F30, use:
=if(D30="","",E30/D30)
continue this downwards.
--
Gary''s Student - gsnu200741
"j5b9721" wrote:
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...
|