"=IF" statement not generating correct response all of the time
I am trying to get my status column to change based upon what the number is the [% Complete) column is. Here is what I would like the desired results to be:
0= "Not Started"; 100="Complete"; and anything else from 1-99 would be "In Progress"
Here is the formula that I have tried, but it's not catching that 100% should be "Complete".
=IF([% Complete]@row = 100, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Here is screenshot of the error.
Help Article Resources
Check out the Formula Handbook template!