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

Find more posts tagged with

Accepted answers

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

All comments

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

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.