IF, AND, and OR equation

Hello. I am trying to make an IF, AND equation with one of the constituents in the AND equation to have an OR function. The equation would go for the "Amount paid" column. The constituents would be "# of pets", "Talent" and "Time". The "Amount paid" would be $125 if # of pets=1, Talent= External OR Rescue and Time=Half.

Here is what I have: =IF(AND(Talent@row = "External", OR(Talent@row = "Rescue"), [# of pets]@row = 1, Time@row = "Half"), 125)

The equations does not show any errors but does not populate the number.

Find more posts tagged with

Accepted answers

Razetto

@mpajuelo Try this instead: =IF(AND(AND(OR(Talent@row = "External", Talent@row = "Rescue"), [# of pets]@row = 1), Time@row = "Half"), "125", "")

All comments

Razetto

@mpajuelo Try this instead: =IF(AND(AND(OR(Talent@row = "External", Talent@row = "Rescue"), [# of pets]@row = 1), Time@row = "Half"), "125", "")

mpajuelo

Works perfectly, thank you!

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.