Multiple IF statements

I am trying to use multiple IF statements and it is not working. For example, I have a column called "HCSA Goal Alignment" which has three conditions that a user can choose. The three conditions are:

· Does not meet (Low priority = 5 points)

· Partially meets (Medium priority = 10 points)

· Completely meets (High priority = 15 points)

I have created another column called "Score" where I am trying to create a formula with multiple IF statements to calculate the result (5, 10, or 15) based on the above three inputs. Here is my formula:

· =IF([HCSA Goal Alignment]@row = "Does not meet (Low priority =5 points)", "5", IF([HCSA Goal Alignment]@row = "Partially meets (Medium priority =10 points)", "10", IF([HCSA Goal Alignment]@row = "Completely meets = (High priority = 15points)", "15")))

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Sharad Jain

The formula is built correctly, and it matches the column name. I tested it in my sheet and it works for me - can you post a screen capture with the formula open, like so:

Screen Shot 2021-09-08 at 4.18.14 PM.png

Check to make sure that the column reference is recognizing the column like mine - it will light up in specific colours. Mine are blue and pink. Does yours look like this?

All comments

hollyconradsmith

Hi @Sharad Jain ,

You should not need to put "" around numbers. Try removing the quotation marks and see if that clears up your issues.

You also do not have a complete if statement for your last statement. Maybe add , 0 after the , 15 to add 0 points if nothing is selected.

Sharad Jain

Hi @hollyconradsmith,

I have removed the quotations around numbers. So it only calculates and returns a value of 5 if the input is "Does not meet (Low priority = 5 points) but it does not return any value (10 or 15) if the input is either "Partially meets (Medium priority =10 points) or "Completely meets = (High priority = 15points). Here's my formula without the quotations around numbers:

=IF([HCSA Goal Alignment]@row = "Does not meet (Low priority =5 points)", 5, IF([HCSA Goal Alignment]@row = "Partially meets (Medium priority =10 points)", 10, IF([HCSA Goal Alignment]@row = "Completely meets = (High priority = 15 points)", 15)))

Sharad Jain

Hello,

I am trying to create an IF statement to calculate "Low",

"Medium", or "High" based on the following logic:

· <= 25 should give "Low"

· 26-45 should give "Medium"

· >= 46 should give “High”

Here’s the formula I am using-

=IF ([Total Priority Score]@row

<=25,"Low", IF ([Total Priority Score]@row >=46,

"High", "Medium")))

Genevieve P.

Hi @Sharad Jain

You have an extra closing parentheses at the end of your IF statement. Try this:

=IF([Total Priority Score]@row <=25, "Low", IF([Total Priority Score]@row >=46, "High", "Medium"))

If this doesn't work, can you post a screen capture of your sheet, blocking out sensitive data?

Cheers,

Genevieve

Sharad Jain

Hi @Genevieve P. ,

I removed the extra parentheses at the end and it is still showing "#Unparseable". Here's the screenshot below:

Thanks,

Sharad

Genevieve P.

Hi @Sharad Jain

The formula is built correctly, and it matches the column name. I tested it in my sheet and it works for me - can you post a screen capture with the formula open, like so:

Check to make sure that the column reference is recognizing the column like mine - it will light up in specific colours. Mine are blue and pink. Does yours look like this?

Sharad Jain

Hi @Genevieve P. ,

Thanks, let me quickly check and get back to you.

Sharad Jain

@Genevieve P. - Thank you so much! It is working now. The column references were not lighting up.

Appreciate your help.

Genevieve P.

I'm glad you got it working!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.