If specific cell is not empty, copy (or enter) formulas andformat
Hi Stacie,
What yo u coulf try is making your formulas a bit clever, if you did
not do so.
Let us say you have in your A column a formula
=myFormula(E2,G2,H2)
Ic cound be
=IF(ISEMPTY(E2),"";myFormula(E2,G2,H2))
A COUNT on column A will not include those rows whithout a value in
the E column, since the COUNT formula only includes numeric values.
HTH,
Woute
|