Hoping for some help with nested IF statements!
In the example below, I'm trying to calculate pricing for a range of products across different stocking units (pack sizes). There are multiple products against which I'm trying to apply a standard differential of:
AAA= CCC-$12
BBB= CCC-$5
CCC= reference price
DDD= CCC+$8
[/URL][/IMG]
So, if Column A=Column B and Pack Code = CCC, no change in price. If Column A=Column B and Pack code=DDD, the value should be Pack code CCC for that product + $8 etc. for all different products and pack codes.
Can this be done and if so, can you guide me on how?
In the example below, I'm trying to calculate pricing for a range of products across different stocking units (pack sizes). There are multiple products against which I'm trying to apply a standard differential of:
AAA= CCC-$12
BBB= CCC-$5
CCC= reference price
DDD= CCC+$8

So, if Column A=Column B and Pack Code = CCC, no change in price. If Column A=Column B and Pack code=DDD, the value should be Pack code CCC for that product + $8 etc. for all different products and pack codes.
Can this be done and if so, can you guide me on how?