Dear all
I am trying to join the following three IF formulas together in one formula however no luck. Each formula works individually in separate cells however would be ideal if it was one formula in one cell in one formula:
=IF(AND(A1=0,B1>=1),"Yes")
=IF(AND(A1>=1,B1=0),"No")
=IF(AND(A1=0, B1=0),"Different")
Any help will be much appreciated
Thanks in advance
Bookmarks