If +AND +OR Statement with multiple outcomes

[scoobydoo]

Hello,

I'm trying to figure out how to write an If Statement to get the following results:

If A = "" AND B = "" THEN "NEITHER"
OR IF A<>"" AND B <> "" THEN "BOTH"
OR IF A <> "" AND B = "" THEN "BUYER INFO"
OR IF A = "" AND B <> "" THEN "SELLER INFO"

Thanks!

 

[BenMiller]

Try this. =IF(A1="",IF(B1="","NEITHER","SELLER INFO"),IF(B1="","BUYER INFO","BOTH"))