How do I return different values in single cell?
 

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!!!

How do I return different values in single cell?
 

=IF(AND(B10,B2="YES"),"B",IF(B10,"A",""))

If B1 is always 0 then

=IF(AND(B10,B2="YES"),"B,"A")

"Zild" wrote:

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!!!

How do I return different values in single cell?
 

=IF(B10,IF(B2="YES","B","A"),"answer undefined")
--
David Biddulph

"Zild" wrote in message
...
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!!!

How do I return different values in single cell?
 

Thank you very much for your help Toppers, that worked just fine!


"Toppers" wrote:

=IF(AND(B10,B2="YES"),"B",IF(B10,"A",""))

If B1 is always 0 then

=IF(AND(B10,B2="YES"),"B,"A")

"Zild" wrote:

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!!!