Give a Rating of 100% if checkboxes with different conditions

Rodrigo Colsa

Hello everyone, this is my first post and I hope I could get some help.

Im trying to create a formula with the following conditions:

100% rating if the YES chechbox is marked

100% rating is the N/A checkbox is marked

0% rating if the NO chechbox is marked

Find more posts tagged with

Formulas

Accepted answers

Nic Larsen

Try this: =IF(OR(YES@row = 1, [N/A]@row = 1), 1, 0)

All comments

Nic Larsen

Try this: =IF(OR(YES@row = 1, [N/A]@row = 1), 1, 0)

Rodrigo Colsa

Thank you @Nic Larsen !!!

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.