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