Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

NESTED IF AND OR Formula help

Topic Labels: Formulas
634 2
Showing results for 
Search instead for 
Did you mean: 

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.


2 Replies 2

HI @Harrison_Jones - this is what you need:

    OR({role} = 'BUS', {role} = 'HOT'),
    {payment method}= 'Checkout'
  ({Total Payment Received} * 0.0275) + 0.75,

Screenshot 2019-07-22 at 19.01.00.png

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


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