Formula to Return 3 Different Answers Based On Cell Value

Hello,

I am trying to create a formula that returns 1 of 3 answers based on the value of the selected cell. Right now I have it set up to show me Complete/Incomplete based on the number 4 being in a column, but it would be more useful for me to see "In Progress" for cells that have a 1, 2, or 3 in them. My current formula is =IF([Count IF Functions]1 = "4", "Complete", "Incomplete")

Any tips on how to achieve this would be appreciated! :)

0="Incomplete"

1-3="In progress"

4="Complete"

Find more posts tagged with

Formulas

Accepted answers

Leslie Merlino

You are on the right track, you just need to nest some IF functions. Try this:

=IF([Count IF Functions]@row = 4, "Complete", IF(AND([Count IF Functions]@row < 4, [Count IF Functions]@row > 0), "In Progress", "Incomplete"))

All comments

Leslie Merlino

You are on the right track, you just need to nest some IF functions. Try this:

=IF([Count IF Functions]@row = 4, "Complete", IF(AND([Count IF Functions]@row < 4, [Count IF Functions]@row > 0), "In Progress", "Incomplete"))

KristiTRUSD

Thank you! That was exactly what I wanted, it worked beautifully! 😀

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.