Forum Discussion

JanaBaker's avatar
JanaBaker
Qrew Cadet
7 years ago

Nested If Formula Error: Expecting Boolean but found number

Hey everybody!  Can someone help me with the below formula?  I get the "expecting Boolean but found number" error at the end of the FIRST If statement.  If i change it to NULL, then the 2nd IF stateme...
Errors
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Aside from the syntax error, it is an odd looking formula, can you explain in words what the logic is trying to do?
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Is the result to be s number or a true /false result?

Can you explain the he logic for when it should �count�?