IF or SWITCH statement to return different formula based on single select status

[Jayna_Fey]

Hello! getting lost in the sauce of nested IF formulas and looking for help.

I have a CRM in airtable that I'd like for a formula to return one of two formulas based on a single select status for that deal.

If the deal is open (any one of 7/10 statuses in the single select), I'd like for it to show the deals age based on today's date

DATETIME_DIFF( TODAY(),{Deal Created}, 'weeks')

If the deal is closed (any of 3/10 statuses in the single select) I'd like for it to show the age of the deal when it was closed:

DATETIME_DIFF({Date Closed or Lost},{Deal Created}, 'weeks')

Thanks for your help!

[TheTimeSavingCo]

Could you give this a shot?

IF(
  OR(
    {Status} = "Closed/Lost Option 1",
    {Status} = "Closed/Lost Option 2",
    {Status} = "Closed/Lost Option 3"
  ),
  DATETIME_DIFF({Date Closed or Lost},{Deal Created}, 'weeks'),
  DATETIME_DIFF( TODAY(),{Deal Created}, 'weeks')
)