#INCORRECT ARGUMENT SET

Shubha

Hi Team,

I have been struggling with this formula I need Output urgently. Any help would be highly appreciated.

=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row, "Shipment on Time", IF(AND([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row, "Shipped Late"))))

Regards

Shubha

Paul Newcome

You have some misplaced parenthesis.

=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row), "Shipment on Time", IF(AND([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row), "Shipped Late"))

Shubha

Hy @Paul Newcome

Thanks for your help. But this formula says Invalid Operations. I'm kind of stuck in between, I even tried using this formula:-

=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row, "Shipment on Time"), ([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row, "Shipped Late"))

& this one says #Unparseable.

Paul McGuinness

Hi @Shubha

Think you just needed to close off that final IF statements False outcome?

=IF(AND([Supplier Tender Date]@row > [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row > [Shipment Date (Actual) (To Site)]@row), "Shipment on Time", IF(AND([Supplier Tender Date]@row < [Shipment Date (Actual) (To Warehouse)]@row, [Supplier Tender Date]@row < [Shipment Date (Actual) (To Site)]@row), "Shipped Late","")

Test is working

Hope that helps

Thanks

Paul

Paul Newcome

You misplaced the parenthesis again closing the AND functions out in the wrong place. Try the formula as I have it posted above.