Help, I'm trying to write a formula that will return different values based on different scenarios (i.e. if Condition 1 is met and condition 2 is met for Scenario A then return "1", etc.):

Scenario Condition 1 Condition 2 Then
A 1M <12M 1
B <1M <12M 2
C 1M 12M 3
D <1M 12M 4


Where condition 1 and 2 are text values not numeric.

My data sets look like this, "Value" is where I want to use a formula instead of manually entering:

Account A B Value
XXX 1M 12M 3
FFF 1M <12M 1
CCC 1M <12M 1
MMM <1M 12M 4
TTT <1M <12M 2
DDD 1M <12M 1
KKK 1M 12M 3
PPP <1M <12M 2

Help!

Trish