Help

NESTED IF AND OR Formula help

Topic Labels: Formulas
1002 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Harrison_Jones
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2

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
) 

Screenshot 2019-07-22 at 19.01.00.png

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

JB

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