Multiple IF statements in the formula
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"))))))))
Best Answer

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"))))
Answers

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.

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"))))

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!