Trying to Remove False from Formula

[Shazir]

Hi, I have been using this below mentioned formula but i am trying to remove the false sign when condition is not met then it should empty rather than false someone can please help in this regard.

=IF(E2<>"","King",IF(F2<>"","King",IF(AND(E2<>"",F2<>""),"King")))

 

[Fluff]

As you are returning the same value each time.
How about

 =IF(AND(E2<>"",F2<>""),"King","")

 

[Shazir]

If there will E2<>"" and E2="" then this below

=IF(AND(E2<>"",F2<>""),"King","")

formula will not work.

I need formula with below conditions.

=IF(E2<>"","King",IF(F2<>"","King",IF(AND(E2<>"",F2<>""),"King")))

Beacuse If E2<>"" and F2="" then result will be king

if E2="" and F2<>"" then result will be king

If E2<>"" and F2<>"" then result will be king

If empty then ""

 

[Fluff]

Oops forgot to change the And to Or

 =IF(OR(E2<>"",F2<>""),"King","")

 

[Shazir]

Thank you so much for the help its working.
Fluff

 

[Fluff]

You're welcome & thanks for the feedback.