Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF Or formula not working

Topic Labels: Formulas
459 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to know what is the proper formula to use this…

IF(Checkincount= 99, TRUE(), FALSE())

I’d like to have an or option meaning

IF(Checkincount= 99, TRUE(), FALSE()), OR IF(Checkincount= 199, TRUE(), FALSE()), OR IF(Checkincount= 299, TRUE(), FALSE())

I can’t seem to find the right formula to use the OR

Meaning, I want it to show if Checkincount is 99 or 199 or 299 etc…

Hope that makes sense.

Thanks

1 Reply 1

If what you really want is for this field to show “True”, or 1 only when {Checkincount} is equal to exactly 99, 199, 299, etc, and show “False”, or 0 otherwise, you could probably do that a little more efficiently like this:

IF(
   RIGHT(
      {Checkincount}&"",
      2
   ) = "99",
   TRUE(),
   FALSE()
)