Nesting IF Statements to provide % Complete

Alex Knisely

Hello All,

I have a project sheet with the following status dropdown:

Not Started

In Progress

Ready for Review

Complete

Canceled

On Hold

Not Applicable

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

Kelly Moore

Hey @Alex Knisely

Typically, %Complete columns are formatted as percents, which means 100%=1, not 100.

If you give us the rest of your percentages, we can help you more specifically build your formula.

=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",1))

Kelly

Kelly Moore

Hey @Alex Knisely

Typically, %Complete columns are formatted as percents, which means 100%=1, not 100.

If you give us the rest of your percentages, we can help you more specifically build your formula.

=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",1))

Kelly

Alex Knisely

Thanks, I was only focused on the syntax of it, and not the content (i.e. %s). I appreciate it.