Nesting IF Statements to provide % Complete
I have a project sheet with the following status dropdown:
Ready for Review
I'd like to write a nested IF statement to provide a value in a percent complete column. I've tried the following but get a #UNPARSEABLE response.
=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",100,)
I've tried many variations of the following, but can't seem to get it. Thanks for the help
Help Article Resources
Check out the Formula Handbook template!