Formula error in Nested IF Loop

r@ndom_w@lker

Hi SS Community,

Trying to automate shipment status using 'date needed by' and 'expected delivery date', but currently have an error with nested if loop #INCORRECT ARGUMENT SET,

=IF([Date Needed by]1 < [Expected Delivery Date (Purchasing Agent)]1, "LATE", IF([Date Needed by]1 >= [Expected Delivery Date (Purchasing Agent)]1, "On-Time"), " ")

The last " " is present so that the formula wont iterate to ontime on each cell while copy pasting.

Any help would be great, Thanks!

JamesR

Try

=IF([Date Needed by]1 < [Expected Delivery Date (Purchasing Agent)]1, "LATE", IF([Date Needed by]1 >= [Expected Delivery Date (Purchasing Agent)]1, "On-Time", " "))

I believe this will work.

r@ndom_w@lker

Thanks James, Worked like a charm!