NESTED IF AND OR Formula help | Airtable Community

Hey,I am looking for some help with a formula I am working on.

I’m trying to achieve the below statement.

IF {role} = “HOT” OR “BUS” AND {payment method}= “Checkout”, then ({Total Payment Received}*0.0275+0.75) ELSE 0

THE {role} within my formula is a “linked” field so I am unsure if that is causing an issue?

Any help would be really appreciated.

Thanks

Page 1 / 1

HI @Harrison_Jones - this is what you need:

IF(

  AND(

    OR({role} = 'BUS', {role} = 'HOT'),

    {payment method}= 'Checkout'

  ),

  ({Total Payment Received} * 0.0275) + 0.75,

  0

)

Format the formula column to be integer or decimal as you require.

JB

HI @Harrison_Jones - this is what you need:

IF(

  AND(

    OR({role} = 'BUS', {role} = 'HOT'),

    {payment method}= 'Checkout'

  ),

  ({Total Payment Received} * 0.0275) + 0.75,

  0

)

Format the formula column to be integer or decimal as you require.

JB

JB you are a HERO!!!

Thank you so much.

Sign up