Formula Error

Bryan Letourneau

Hello,

I continue to encounter an incorrect argument error however the formula worked correctly with a previous entry and I cannot determine the cause. See below:

Error encountered with top entry

The formulas are precisely the same with the exception of references and I've checked the formula probably 20 times now and can't seem to identify the problem. I understand there is likely a parenthesis missing but have spent the last hour trying to figure out where.

Any help would be appreciated.

Paul Newcome

You need to remove the = from before the second IF, and you need to move one of the closing parenthesis from the end to after the first OR statement.

Paul Newcome

You need to remove the = from before the second IF, and you need to move one of the closing parenthesis from the end to after the first OR statement.

Bryan Letourneau

That solved it, thanks Paul!

Paul Newcome

Happy to help. 👍️