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

Nic Larsen

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

Nic Larsen

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

Rodrigo Colsa

Thank you @Nic Larsen !!!