OK..I'm trying to put together a spreadsheet that uses an "if then" statement, but it has been so 'ong, I forget how to do one that can have 4 different outcomes?
So lets say A1 can have a value of "1" or "2", then B1 can be "A" or "B"
I want C1 to reflect a certain value if A1 is "1" and B1 is "A", then a different number for A1 being "2" and B1 being "A", Then A1="1" and B1="B" etc...
So lets say
(A1,B1) = "1,A", "1,B", "2,A", or "2,B"
1,A=Value 1
1,B=Value 2
2,A=Value 3
2,B=Value 4
This is as far as I got before my brain failed...lol
=IF(AND(A1=1, B1="A"), Value 1, ???????????
Am I even close? LOL