Formulas to calculate only when data is populated.
 

I have IF formulas referencing information that is populated monthly. I've
copied the formula's down for the next several years, but won't need those
formula's to calculate until the corresponding month of data is input. So my
IF formula's are yielding either TRUE or FALSE results because there isn't
any data to calculate from. Is there a way to engage a formula only when data
is populated in a certain field?

Formulas to calculate only when data is populated.
 

Something like ...

=IF(cell_is_empty,"",your_formula)

"ispy4mi6" wrote:

I have IF formulas referencing information that is populated monthly. I've
copied the formula's down for the next several years, but won't need those
formula's to calculate until the corresponding month of data is input. So my
IF formula's are yielding either TRUE or FALSE results because there isn't
any data to calculate from. Is there a way to engage a formula only when data
is populated in a certain field?

Formulas to calculate only when data is populated.
 

=IF(LEN(A1)=0,"",YourFormula)

hth
Vaya con Dios,
Chuck, CABGx3



"ispy4mi6" wrote:

I have IF formulas referencing information that is populated monthly. I've
copied the formula's down for the next several years, but won't need those
formula's to calculate until the corresponding month of data is input. So my
IF formula's are yielding either TRUE or FALSE results because there isn't
any data to calculate from. Is there a way to engage a formula only when data
is populated in a certain field?