Formula with a range
Hi,
Calling on all formula guru's. I can get my formula to work for the absolute parts but when it comes to a range I get the #unparseable error. Below are the two formula's I've tried.
=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row > .01 and <.1, "In Progress")))
=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row = .01.99, "In Progress")))
Thanks!
Best Answers

If your Complete column is blank you can use this formula. This way you don't need to have a range.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
Let me know if that works for you!

Thank you so much!
Answers

If your Complete column is blank you can use this formula. This way you don't need to have a range.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
Let me know if that works for you!

Thank you so much!

You're very welcome!🙂
Help Article Resources
Categories
Check out the Formula Handbook template!