Trying to use the dollar sign indicator with a nested IF statement.
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")))))
Answers

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 semicolon to a comma.
Did it work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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
Categories
Check out the Formula Handbook template!