=IF(OR(E7<>"",E8<>""),"",IF(AND(E6="(Yes)",E7=""),"Enter %",""))
Select allOpen in new window
=IF(OR(E7<>"",E8<>""),"",IF(E6="(Yes)", "OR $",""))
=IF(AND(E6="(YES)",AND(E7="",E8="")),"Enter %","")
=IF(AND(E6="(YES)",AND(E7="",E8="")),"OR $","")
Open in new window
In F8:Open in new window