Formula is not working

StephanieWW

Hi - I cannot figure out why this formula won't work -

=IF(AND(TODAY(10) >= [End Date]@row, IF([% Complete]@row, <0.75, "yellow")))

Thanks for your help!

Jeff Reisman

When creating IFs, you need to make sure you have at least a criteria and a true condition. The syntax is IF(logical expression, true condition, false condition). When using AND to specify two criteria, you have to make sure you close out the AND before going to your true condition.

Try this. The part in BOLD is your criteria. See the AND(...) is closed off, with your two logical expressions that must be true inside of it, separated by a comma. The closed off AND(...) is followed by a comma, and then in italics is your true condition.

=IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row <0.75), "yellow")

Jeff Reisman

When creating IFs, you need to make sure you have at least a criteria and a true condition. The syntax is IF(logical expression, true condition, false condition). When using AND to specify two criteria, you have to make sure you close out the AND before going to your true condition.

Try this. The part in BOLD is your criteria. See the AND(...) is closed off, with your two logical expressions that must be true inside of it, separated by a comma. The closed off AND(...) is followed by a comma, and then in italics is your true condition.

=IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row <0.75), "yellow")

StephanieWW

Thank you a million times over!