Formula Roadblock

John P.

I have a hit roadblock, and I needed a little help or additional eyes. The formula should be something of ease, but not working or responding the way it should. Please see my screen shot below. Everything about this works except for when I hit 100%. It does not return my “6-Complete” Statement. When it hits 100% it remains in “1-In Progress”. I have tried reversing the 0 and 100 and still did not work. Let me know if you see anything that I might have overlooked. Thank you

Carson Penticuff

You are very close. Percentages are treated as decimals: 1 = 100%, 0.5 = 50%, etc.

=IF([% Complete]@row <= 0, "5-Not Started", IF([% Complete]@row = 1, "6-Completed", "1-In Progress"))

Carson Penticuff

You are very close. Percentages are treated as decimals: 1 = 100%, 0.5 = 50%, etc.

=IF([% Complete]@row <= 0, "5-Not Started", IF([% Complete]@row = 1, "6-Completed", "1-In Progress"))

John P.

Amazing.. It worked. Thank you very much