Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto calculate formulas when new data is entered | Excel Discussion (Misc queries) | |||
Having data automatically populated in a different sheet | Excel Worksheet Functions | |||
How do I calculate formulas for yes/no data | Excel Worksheet Functions | |||
Conditional formulas: color code text populated cells? | Excel Worksheet Functions | |||
Will not calculate average/median formulas;acts like no data in c. | Excel Worksheet Functions |