#INCORRECT ARGUMENT SET

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

Find more posts tagged with

Accepted answers

All comments

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?

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.