IF/OR/AND Statement

Michael Foster

Hi I'd like to do a OR statement with 2 and Statements included - following formula is resulting in an error and I can' see why:

=IF(

OR(

AND([Due Time]@row = "EoD", [Needs Removing]@row = 0),

AND(Status@row = "Not Started", Done@row = 0),

"1", "2"))

Can some please take a look over it and advise why and amend.

Many thanks in advance.

Mike

Paul Newcome

You forgot to close out your OR statement (and have an extra closing parenthesis on the end of the formula as a result).

=IF(OR(AND(..........), AND(..........)), "1", "2")

Paul Newcome

You forgot to close out your OR statement (and have an extra closing parenthesis on the end of the formula as a result).

=IF(OR(AND(..........), AND(..........)), "1", "2")

Michael Foster

Parenthesis blind - thanks very much @PaulNewcome that has worked as i'd hoped.

Paul Newcome

Happy to help. 👍️