Nested IF function

I am currently trying to create an IF function that will mark a row as overdue if in the 'status' cell is "Paid" or "paid through urgent payment".

At the moment i have it working for just one criteria, =IF(AND([Days Until Delivery]@row < 0, NOT(Status@row = "PAID")), "OVERDUE", "")

where do i add the second criteria "Paid Through Urgent Payment" - i cant work it out :-S

Thanks

Jasmine

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Andrée Starå

Hi Jasmine,

Which status options do you have?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Jasmine Brown

Please find step by step attached. hope this explains more?

Status options below.docx

Andrée Starå

Try something like this.

=IF(AND([Days Until Delivery]@row < 0; NOT(OR(Status@row = "PAID"; Status@row = "Paid Through Urgent Payment"))); "OVERDUE"; "")

The same version but with the below changes for your and others convenience.

=IF(AND([Days Until Delivery]@row < 0, NOT(OR(Status@row = "PAID", Status@row = "Paid Through Urgent Payment"))), "OVERDUE", "")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.