Formula for Priority Cell

AB

Hello All:

 

I am having a difficult time creating a formula that will give me Priority. Below are my rules for Priority Status. Thanks

 

Urgency High

If Impact High and Urgency High, then Priority is 1

If Impact Med and Urgency High, then Priority 2

If Impact Low and Urgency High, then Priority 3

 

Urgency Med

If Impact High and Urgency is Med, then Priority 2

If Impact Med and Urgency is Med, then Priority 3

If Impact Low and Urgency is Med, then Priority 4

 

Urgency Low

If Impact High and Urgency is Low, then Priority 3

If Impact Med and Urgency is Low, then Priority 4

If Impact Low and Urgency is Low, then Priority 5

AB

Here is the first part of my formula for Urgency High and Impact High:

=IF(AND(Impact12 = "High", Urgency12, "High"), "1"))