# This formula ignores multiple AND's

• 0
• Question
• Updated 3 years ago

If(IsNull([Age]) and IsNull([Salary]) and IsNull([Expected OTE (Overall Total Earnings)]) ,0,1). If all of those fields are NULL then I expect 1.

The fields are ether numeric or Currency

• 10 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,448 Points
If(IsNull([Age]) and IsNull([Salary]) and IsNull([Expected OTE (Overall Total Earnings)]) ,1,0)

I think that you need to just flip the 0 and 1.  Be sure that those fields are set to not treat blank as zero.
• 10 Points
Hi, yeah they are set to not treat blank as zero, but if populate one of the fields with data it changes it to a "1", where I would expect it be a 0 as the other fields are still blank.

QuickBaseCoach App Dev./Training, Champion

• 67,448 Points
Please explain in English words what you are looking to do and i can help you with the formula to do that.  or else give a couple of examples.
• 10 Points
Hi, I have three fields. If ALL of these three fields are blank, then the formula should return the number zero. If only one of the fields is populated, it should still return zero. If ALL of the fields are populated then the formula should return the number 1.

QuickBaseCoach App Dev./Training, Champion

• 67,448 Points
try this

If(not IsNull([Age]) and not IsNull([Salary]) and not IsNull([Expected OTE (Overall Total Earnings)]) ,1,0)
• 10 Points
Perfect Thanks,