Capture.PNG
I was just wondering why my formula of =IF(F2={"A","B","C"},1,0) was only giving me the value of 1 when the cell = A and not for B and C
Capture.PNG
I was just wondering why my formula of =IF(F2={"A","B","C"},1,0) was only giving me the value of 1 when the cell = A and not for B and C
G1=IF(OR(F1={"A","B","C"}),1,0)
Try this, may be this will work for you
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks