Hello worldwide Excel community,
I was hoping you could help me tweak a formula I am trying to use.
In Column A I have data with values 1, 0 or (blank), and in column B we have the same values but representing something different. In column C I'd like it to return a "Yes") when Column A is 1 and B is 0.
I have been trying the below but keep getting errors:
=IF((AND(A1=1,B1=0),"Yes"),"No")
Can someone maybe let me know where I am going wrong and offer an alternative?
Any input appreciated!
KW
Last edited by KevyWevz; 11-02-2020 at 03:25 PM.
Try:Formula:
=IF(AND(AU6=1, C6=0), "Yes", "No")
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Solved, that was quick! Thank you, TMS!Originally Posted by TMS
Try:Formula:=IF(AND(AU6=1, C6=0), "Yes", "No")
We do our best
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks