Welcome!

Nested IF Statments

I'm trying to add the below "IF Statement" but I get the "#UNPARSEABLE" error. "Weight22" is cell that contains the "70%" (which is calculated from a formula. I want the IF Statement to return the "Below Average" / "Average"/ "Very Good"/ "Excellent" based on the % cell next to it.

I'm new to smart sheets so I don't really have a clue what is going on. In excel the formula works fine.

=IF(Weight22 <=69%,"Below Average",IF(Weight22 <=79%,"Average",IF(Weight22 <=89%,"Very Good",IF(G11 <=100%,"Excellent"))))

If statement screen shot.JPG

Find more posts tagged with

Comments

Shaine Greenwood

Hello,

Smartsheet functions need percentages to be turned into their decimal equivalent. Instead of using the percent sign, use a decimal value:

=IF(Weight22 <=0.69,"Below Average",IF(Weight22 <=0.79,"Average",IF(Weight22 0.89,"Very Good",IF(G11 <=1,"Excellent"))))

Shaine Greenwood

Hello,

Smartsheet functions need percentages to be turned into their decimal equivalent. Instead of using the percent sign, use a decimal value:

=IF(Weight22 <=0.69,"Below Average",IF(Weight22 <=0.79,"Average",IF(Weight22 0.89,"Very Good",IF(G11 <=1,"Excellent"))))

Sign in to join the conversation!

Quick Links

Trending discussions

Timeline Widget Filter on the Dashboard
The timeline widget seems to only allow filters to be set when you are editing the widget (see green highlight screenshot). Which is fine, but it would be more valuable to have regular users be able to adjust filters directly from the dashboard, similar to how there is an option to adjust the timescale. Am I missing…
“File Creation Restriction”
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks