# Trying to use the dollar sign indicator with a nested IF statement.

Options
✭✭✭

I have a column showing the dollar signs and I am trying to get it to change based on the percentage of money left over from the project.

So, if the percentage is

Zero to 10%, it would get 5 dollar signs

OR

10% to 40%, it would get 4 dollar signs

OR

40% to 50%, it would get 3 dollar signs

OR

50% to 75%, it would get 2 dollar signs

OR

75% to 95%, it would get 1 dollar sign

OR

95% or higher, it would get no dollar sign

I am trying to create a nested statement.. This is what I have so far but it is not working correctly..

=IF([%]@row <= 0.1, "Five", IF([%]@row <= 0.4, "Three", IF([%]@row <= 0.75, "Two", IF([%]@row < 0.95, "One", IF([%]@row >= 0.95, "Empty")))))

• ✭✭✭✭✭✭
Options

Hi Buster,

Try something like this.

=IF([%]@row <= 0,1; "Five"; IF([%]@row <= 0,4; "Four"; IF([%]@row <= 0,5; "Three"; IF([%]@row <= 0,75; "Two"; IF([%]@row <= 0,95; "One"; IF([%]@row <= 1; "Empty"))))))

The same version but with the below changes for your and others convenience.

=IF([%]@row <= 0.1, "Five", IF([%]@row <= 0.4, "Four", IF([%]@row <= 0.5, "Three", IF([%]@row <= 0.75, "Two", IF([%]@row <= 0.95, "One", IF([%]@row <= 1, "Empty"))))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!