Forum Discussion
Solved
add criteria to the following formula
I would like to add criteria to the following formula that says if cell BB30 has any data then true, if not cell remains blank =IF(AND( IF($D$20>0,$AB30<$AC30,1), IF($F$20>0,$AD30<$AE30,1), IF($H...
Hi Greg,
You formula
=IF( AND(...), ($Q30/$P30), "")
you could modify as
=IF( AND(...)*(LEN(BB30)>0), ($Q30/$P30), "")
If any data it changes nothing, if not entire expression is FALSE and formula returns empty string
Hi Greg,
You formula
=IF( AND(...), ($Q30/$P30), "")
you could modify as
=IF( AND(...)*(LEN(BB30)>0), ($Q30/$P30), "")
If any data it changes nothing, if not entire expression is FALSE and formula returns empty string