+ Start a Discussion
Christina Lam 7Christina Lam 7 

Checkbox IF formula: Combining AND / OR

Hello! How do you combine an IF formula if the checkbox includes AND / OR components?

The checkbox field is only checked if (1. when another checkbox field is checked) PLUS (2. another checkbox is over a percentage OR 3. another checkbox is under a percentage). The issue right now is the checkbox will not uncheck when the other checkbox field is unchecked. The checkbox must only check when the other checkbox is checked along with either one of the over or under percentage fields.

Thank you!!
Best Answer chosen by Christina Lam 7
Steven NsubugaSteven Nsubuga
IF ( AND(AnotherCheckbox__c, OR( UnderPercent__c< 0.1, OverPercent__c > 0.5)) , true, false)

All Answers

Steven NsubugaSteven Nsubuga
IF (AND((AnotherCheckbox__c, OR((OverPercent__c > 0.10) , (UnderPercent__c < 0.50))), true, false))

 
Christina Lam 7Christina Lam 7
Hi Steven,

It is showing up as a syntax error: missing a ')' . I tried to place the ) at the end of AnotherCheckbox_C, but it still shows up as an error. Thanks for taking the time to help out!
Steven NsubugaSteven Nsubuga
IF ( AND(AnotherCheckbox__c, OR( UnderPercent__c< 0.1, OverPercent__c > 0.5)) , true, false)
This was selected as the best answer