IF(AND(OR Statement

I need assistance with a formula.

=IF(AND(OR([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000), [Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000),"Yes","No")))

Type1 meets 50000 = Yes / Type1 doesn't meet 50000 = No

Type2 meets 30000 = Yes / Type2 doesn't meet 30000 = No

Find more posts tagged with

Formulas

Accepted answers

Eric Law

@nhornCGT Sorry, had parenthesis in the wrong place. Try this

=IF(AND([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000), "Yes", IF(AND([Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000), "Yes", "No"))

All comments

Eric Law

@nhornCGT =IF(AND([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000)), "Yes", IF(AND([Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000), "Yes", "No")

You don't need the OR as you are just using this logic

Type1 meets 50000 = Yes / Type2 meets 30000 = Yes / No

nhornCGT

@Eric Law,

Thank you for the response. I'm getting #unparaseable. When I remove the second statement, it works perfectly but does not seem like the second IF(AND statement.

I appreciate your help. Thoughts?

Eric Law

@nhornCGT Sorry, had parenthesis in the wrong place. Try this

=IF(AND([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000), "Yes", IF(AND([Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000), "Yes", "No"))

nhornCGT

@Eric Law

That was it! Thank you so much!!

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.