Multiple IF statements in the formula

Myra Kodidela

Hi!

I want to create a priority matrix using urgency and important. I've used this formula below. There is no error on the formula but the cell only returns P2. I feel I'm doing something wrong with adding multiple IF statements. Please help

=IF(Urgency@row = "NOT URGENT", IF(Importance@row = "IMPORTANT", "P2", IF(Urgency@row = "URGENT", IF(Importance@row = "IMPORTANT", "P1", IF(Urgency@row = "NOT URGENT", IF(Importance@row = "IMPORTANT", "P3", IF(Urgency@row = "NOT URGENT", IF(Importance@row = "NOT IMPORTANT", "P4"))))))))

Myra Kodidela

Thank you, it worked when I used

=IF(AND(Urgency@row = "URGENT", Importance@row = "IMPORTANT"), "P1", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "IMPORTANT"), "P2", IF(AND(Urgency@row = "URGENT", Importance@row = "NOT IMPORTANT"), "P3", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "NOT IMPORTANT"), "P4"))))

Paul Newcome

Try a series of IF/AND combos instead.

=IF(AND(Urgency@row = "NOT URGENT", Importance@row = "IMPORTANT"), "P2", IF(AND(...........

However... This can get rather long and unwieldy very quickly depending on the number of combinations you can have. I generally suggest setting up a matrix on a separate sheet and using a formula with cross sheet references to pull the appropriate output.

Myra Kodidela

Thank you, it worked when I used

=IF(AND(Urgency@row = "URGENT", Importance@row = "IMPORTANT"), "P1", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "IMPORTANT"), "P2", IF(AND(Urgency@row = "URGENT", Importance@row = "NOT IMPORTANT"), "P3", IF(AND(Urgency@row = "NOT URGENT", Importance@row = "NOT IMPORTANT"), "P4"))))

Paul Newcome

Happy to help. 👍️