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 Formula Issues

Topic Labels: Formulas
143 1
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Not sure this is possible but I can’t seem to get this to work when I add the second part. I have a formula that works this way 'If Base Rate = 0 and IF UM= “Pounds” then Weight / 2000 * Price, IF Base =0 and IF UM= “Kilograms” then Weight / 2200 * Price, IF Base Rate = 0 and IF UM = “Each” then “Price”

'IF Base Rate Not Equal to 0, and IF UM=“Pounds” then Set Weight/2000 * Price, IF Base Rate not eqaul to 0 and IF UM =“Kilograms” then Set Weight / 2200 * Price, If Base Rate not equal to 0 and If UM =“Each” then “Price”

My Formula:
IF({Base Rate } = 0,IF({UM} = “POUNDS”, ({Weight}/2000 * {Price}), IF({Base Rate UM} = “KILOGRAMS”, ({Weight}/2200 * {Price) , IF({UM} = “EACH”, {Price}, IF({Base Rate} !=0, IF({UM}= “POUNDS”, ({Set Weight}/2000 * {Price})…

It computes the first part when the base rate is 0, but when the base rate is not 0, that part of the formula doesnt compute.

Any insight would be appreciated.

10 - Mercury

Hey @Smyth_County!

Okay, I think this should do it.

In case I am misunderstanding your requirements, I’ll write out what we’re looking at here.

1. Base Rate = 0

• {UM} = “POUNDS”
• ({Weight} / 2000) * {Price}
• {UM} = “KILOGRAMS”
• ({Weight} / 2200) * {Price}
• {UM} = “EACH”
• {Price}
2. Base Rate !== 0

• {UM} = “POUNDS”
• ({Set Weight} / 2000) * {Price}
• {UM} = “KILOGRAMS”
• ({Set Weight} / 2200) * {Price}
• {UM} = “EACH”
• {Price}
``````IF(
{Base Rate} = 0,
IF(
{UM} = "POUNDS",
({Weight} / 2000) * {Price},
IF(
{UM} = "KILOGRAMS",
({Weight} / 2200) * {Price},
IF(
{UM} = "EACH",
{Price}
)
)
),
IF(
{UM} = "POUNDS",
({Set Weight} / 2000) * {Price},
IF(
{UM} = "KILOGRAMS",
({Set Weight} / 2200) * {Price},
IF(
{UM} = "EACH",
{Price}
)
)
)
)
``````

Let me know if that meets your requirements!
Be sure to check the field names to make sure they fit the field names in your base.