Nested Formula Issues

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”

I need to add this:
'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.

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.