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

Buster Davis

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")))))

Andrée Starå

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

✅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!