IF cell is blank then use formula

[Kelli Webb]

Hello,

This is probably the easiest to resolve, but I'm struggling...

If column C is blank, then apply the formula in column D e.g. Yes or Blank

What the result should be is in column E

take care & thanks people, Kelli

 

[abhi0300]

I am afraid I didn't understand your requirement fully. Wherever there is a blank in Col C, your formula is returning Yes in Col D (as also it should, per Col E). What is the change in Row 19 so you want it to return blank?

 

[bosco_yip]

Maybe,

In D2, formula copied down :

=IF((B2<>"")*(C2<>"")+SUMPRODUCT(1-ISERR(SEARCH("Support",C$1:C1))),"","Yes")

 

[Kelli Webb]

Maybe,

In D2, formula copied down :

=IF((B2<>"")*(C2<>"")+SUMPRODUCT(1-ISERR(SEARCH("Support",C$1:C1))),"","Yes")

View attachment 74074

Perfect as always. thanks Bosco!