OR function within an IF formula

[Thistledown]

=IF(OR([Task Name]12 = "", "", [Due Date]12 < TODAY(), IF(AND(Status12 = "Complete", [Completed date]12 <= [Due Date]12, ISDATE([Completed date]12)), "PASS", "FAIL")))

This is being returned as 'Missing or Invalid Parameters'. (this formula is in Smartsheet rather than Excel hence the different cell references). Please help.

IF OR Error.xlsx

[Jacc]

OR([Task Name]12 = "", "",

So shouldn't there be a second condition instead of another set of "" ?

[Thistledown]

Ok, so have removed the second set of "" but still not working:

=IF(OR([Task Name]12 = "", [Due Date]12 < TODAY(), IF(AND(Status12 = "Complete", [Completed date]12 <= [Due Date]12, ISDATE([Completed date]12)), "PASS", "FAIL")))

[Jacc]

I assume the or is a test of two parameters before going into the second IF. In that case, where is the ending parenthesis of the OR?

[e.isayev]

I think error is in the third paramether of the OR function. In the AND function you put three paramethers and right after closed the second IF function. Complete the function and satisfy every parameter

[Thistledown]

In my own words the formula is saying as follows:

Key to cell names:
A1 - Task name
B1 - Status
C1 - Due Date
D1 - Completed Date


IF A1 is blank OR C1 is less than today's date, RETURN result "", otherwise IF B1 says "Complete" AND D1 is equal to or earler than C1 AND D1 is populated with a date, RETURN "Pass", if not, then RETURN "Fail". So string below:

=IF(OR([Task Name]24 = "", [Due Date]24 < TODAY(), "", IF(AND(Status24 = "Complete", [Completed date]24 <= [Due Date]24, ISDATE([Completed date]24)), "PASS", "FAIL")))

Still doesn't work.

[SPACKlick]

IF(OR(A1=””, C1<Today()), “”, IF(and(B1=”Complete”, D1<=C1, isdate(D1)), “Pass, “Fail”))

Using your cell references

Your current one misses a closed bracket after the OR and tests the following

If One of
[task name]is blank
OR due date is less than today
OR "blank"
OR IF All of
Status24=complete
AND completed before due
AND there is a completed date
Then print pass or fail

so you have a really long OR but no outputs for your if.

[Thistledown]

i have put the missing closed bracket in but still get the error message "UNPARSEABLE"

=IF(OR([Task Name]24=””, [Due Date]24<Today()), “”, IF(and(Status24=”Complete”, [Completed date]24<=[Due Date]24, isdate([Completed date]24)), “Pass, “Fail”))