Testing for multiple conditions

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a formula - checkbox field where I would like to mark records with a check box.  I used the following but this does not an accurate result. 

If(

[Address: Country]= "Australia" And 

[Division] <> "Retail",

[Division] <> "Home Improvement",

[Division] <> "Oxygen", 

true, false)

Will appreciate some help. 

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

  • 0
  • 1


If([Address: Country]="Australia" and 

[Division]<>"Retail" and

[Division]<>"Home Improvement" and

[Division]<>"Oxygen",

true, false)

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Many thanks.