Using IF Statements in Airtable for Conditional Logic

Other Questions Airtable
1

I’m currently working with Airtable, which is similar to Excel but has its own unique formula system. I am facing challenges with a specific formula I need to implement.

I have three categories: UE, PE, and EE, corresponding to the columns GradeF, ZipcodeF, and SchoolF. The formula will be applied in the ‘Eligible’ column. My objective is as follows: when GradeF is ‘UE’, it should result in ‘UE’. If GradeF is ‘PE’, I need to check if either ZipcodeF or SchoolF is ‘EE’ or ‘PE’; if any of them qualify, it should return ‘PE’, otherwise ‘UE’. If GradeF is ‘EE’, I want to check if ZipcodeF or SchoolF is ‘EE’; if true, it should yield ‘EE’; otherwise, it should return ‘UE’.

Here’s the formula I crafted:

IF(GradeF = 'UE', 'UE', IF(GradeF = 'PE', IF(OR(ZipcodeF = 'EE', ZipcodeF = 'PE', SchoolF = 'EE', SchoolF = 'PE'), 'PE', 'UE'), IF(GradeF = 'EE', IF(OR(ZipcodeF = 'EE', SchoolF = 'EE'), 'EE', 'UE', ''))))
2

Hey Alice, make sure your parentheses are balanced and check if your Airtable fields are spelled correctly and match case sensitivity. Sometimes small typos can cause issues. Double-check field names or try using quotation marks carefully! Debugging step-by-step in Airtable’s formula editor can also help find errors.