Excel, IF statement with AND, OR - Two Columns. Nine Combinations
Posted on 2012-03-23
We need to identify NAFTA shipments, with a formula inserted into a spreadsheet.
I have tried a number of IF statements with OR and AND, but I cannot get it to work.
3 countries = 9 combinations
Column A = Origin Country
Column B = Destination Country
What we are trying to do:
If the value in A1 = USA, MEX, or CAN
and the value in B1 = USA, MEX, or CAN, then C1 returns "NAFTA".
otherwise, "" )
Any advise that you can provide is appreciated.