Apr 26 2019 01:53 PM
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$20>0,$AF30<$AG30,1), $AH30<$AI30, $AJ30<$AK30, $AL30<$AM30, $AN30<$AO30, $AP30<$AQ30, (($D$20>0)+($F$20>0)+($H$20>0)) ), ($Q30/$P30),"")
Apr 26 2019 02:01 PM
Solution
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
Apr 26 2019 02:01 PM
Solution
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