Can someone assist me with this? I believe the correct way of approaching this is an IFF statement with multiple Logical conditions.
I want to compare column A vs B.
IF A1 = M & B1 = F C1= Male to Female
IF A2 = F & B2 = M C2= Female to Male
IF A3 = M & B3 = 0 C3= Male to No Gender
IF A4 = F & B4 = 0 C4= Female to No Gender
Any assistance would be greatly appreciated.
Thank you
Bookmarks