NESTED IF AND OR Formula help

[Harrison_Jones]

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

[JonathanBowen]

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

[Harrison_Jones]

JB you are a HERO!!!
Thank you so much.