How do I return different values in single cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is the general idea of what I need to do;

A1 = "A" if B1 > 0
BUT
A1 = "B" if B1 > 0, AND B2 = "YES"

Any help please!!!
 
=IF(AND(B1>0,B2="YES"),"B",IF(B1>0,"A",""))

If B1 is always > 0 then

=IF(AND(B1>0,B2="YES"),"B,"A")
 
Back
Top