IF(AND(OR Statement Help

Doris F

I want to write a statement to determine if a record was extended on time?

I have a calculated column that determines if a record extension is required [Extension Required] , and the responses are Yes or No.

I also have columns for the record [Due Date], and the [Extension Approval Date]

Logic: If the value in the [Extension Required] column is Yes, AND either the [Extension Approval Date] is greater than the [Due Date], OR [Extension Approval Date] is "N/A", THEN the record was not extended on time.

I tried the following statement, but it returned: #UNPARSEABLE

=IF(AND(OR([Extension Required]@row=Yes, ([Extension Approval Date]@row < [Due Date]@row) [Extension Approval Date]@row ="N/A"), "No", "Yes"))

Please Help, Thank you

Mike Wilday

Hi Doris, Try this one:

=IF(AND([Extension Required]@row = Yes, OR([Extension Approval Date]@row > [Due Date]@row,[Extension Approval Date]@row ="N/A")), "No", "Yes"

It's all in how you nest the OR statement. It has to be within the AND statement to make either of the OR and the Extension required row = yes calculate together. Let me know if it worked!