Using "OR" in a formula

Hi there -

Trying to note that if a site has a Tier III Exterior OR if a different column titled EXTERIOR FRAME DESIGN says "Complete", a 0 is entered, otherwise it is 20. When I use the below formula, i just get a blank cell...

=IF([EXTERIOR SCOPE TIER]@row = "TIER III", OR([EXTERIOR FRAME DESIGN]@row = "Completed", 0, 20))

Find more posts tagged with

Accepted answers

All comments

Jaime Elizabeth

@aecross

Can you share a screenshot of your sheet? I can try to help.

~Jaime

Genevieve P.

Hey @aecross

I agree that it would be helpful to see a screen capture!

In the meantime, the structure of an OR statement is like this:

=IF(OR(this = "", that = ""), true, false)

So in your case, try:

=IF(OR([EXTERIOR SCOPE TIER]@row = "TIER III", [EXTERIOR FRAME DESIGN]@row = "Completed"), 0, 20)

Cheers,

Genevieve

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.