#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Number Range Logic

Options
edited 12/09/19

I am trying to craft a formula that sources a numerical value in a different column and, based on that value, prints a skill level. Here's the formula:

=IF([Points]1 <99, IF([Points]1 <199, “Apprentice”, IF([Points]1 <499, “Amateur”, IF([Points]1 <999, “Pro”, IF([Points]1 <1999, “Veteran”, IF([Points]1 <= 3999, “Expert”, IF([Points]1 = 4000, “Master”)))))))

I keep getting the #UNPARSEABLE error. I have searched the forums for and found good ideas on how to make this work however, none of it seems to work for me.

Any ideas on what I'm missing?

• Options

I have tried this formula as well:

=IF([Points]1 <99, “”, IF([Points]1 <199, “Apprentice”, IF([Points]1 <499, “Amateur”, IF([Points]1 <999, “Pro”, IF([Points]1 <1999, “Veteran”, IF([Points]1 <= 3999, “Expert”, IF([Points]1 = 4000, “Master”)))))))

So, nothing is printed in the cell if you have less than 100 points.

• Options

It turns out that the problem was that my editor was inserting rich-text quotes. Switching to an editor that didn't use rich-text, fixed the issue.

This discussion has been closed.