Nested Formula Issues

[Smyth_County]

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.

[Ben.Young]

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.