I have created a number of formula fields that evaluate to true if a condition is met. There are three conditions that I'm using in yet another formula field that if evaluate to true satisfy the entire condition. My problem is that in one of the "sub formula fields" the conditions is that any and all the records for that field are valid. Some thing like:

That is true if all values are valid but I have several formula fields where only a subset of the values makes them true. In two instances the whole set of values in this field make it true. So Formula A is only true for values 10, 20, 30, and 40. Formula B is only true for values 20, 40, 60, but Formula C is valid for any and every value in the field.

 

Therefore how do I write the formula field?

 

IIF ({BUDGET_COMMITMENTS.ACCOUNT} = Any and all values ,1 ,0 )

 

The syntax is :