Help with AND / OR / IF function

[Eddie_Ross]

Hello all,

Thank you in advance for your help. It seems I have a simple formula requirement but can’t get my head around the Airtable syntax. Pseudo code below:

IF((eligible = yeswithplan OR eligible = yeswithoutplan) AND (purchase timeframe
= 12 weeks OR purchase timeframe = 3 - 6 MONTHS) AND (stage != just looking))
RETURN true OR(appointment != empty) RETURN true ELSE false

Would someone be so kind to translate this into the formula for Airtable?

Eddie

[Justin_Barrett]

Welcome to the community, @Eddie_Ross! :grinning_face_with_big_eyes: Maybe this will help:

If you need specific help after checking that out, let me know! :slightly_smiling_face: