I know the description is vague but I am not sure how to explain this one. I am working on a sheet that has all the information required BUT I am having trouble figuring out the formula to do the math.
I want to do the following with the following information:
Columns D and E are fixed numbers which equal the cost of the items. To hopefully make this simple the package deal at cost would be D4+E4+E4=F4
What I am trying to do is take O to be a Fixed Percentage of increase of E4 (Qty 1) and it provide the Dollar Amount in N4.
Then have M4 create a Auto Percentage and L4 equal the dollar amount increase of D4. All of this using a fixed amount in P4 which would be $60.
<tbody>
</tbody>
Item Once Dollar amount changes, Item 2 Dollar amount changes ( Base on Product Number ) In this Example Item 2 happens to be the same Product Number so its dollar amount is same in 3 fields... The Idea is to keep all Product numbers to have the same % and $ amounts and then have Item 1's % and $ amounts change to equal the $60 mark.
Anyone have an Idea.. I have tried a few and come up with BIG errors...
As always any assistance is greatly appreciated!!
Thank you!
I want to do the following with the following information:
Columns D and E are fixed numbers which equal the cost of the items. To hopefully make this simple the package deal at cost would be D4+E4+E4=F4
What I am trying to do is take O to be a Fixed Percentage of increase of E4 (Qty 1) and it provide the Dollar Amount in N4.
Then have M4 create a Auto Percentage and L4 equal the dollar amount increase of D4. All of this using a fixed amount in P4 which would be $60.
ITem 1(Fixed) | Item 2(Fixed) | Item 1 ( New Price ) | Item 1 ( Auto % ) | Item 2 qty 1( New Price ) | Item 2 Qty 1 (Fixed % ) | PKG Total(Fixed) Item1+Item2+Item2 |
17.22 | 17.54 | 19.66 | 14.18% | 20.17 | 15.00% | 60.00 |
14.79 | 17.54 | 19.66 | 32.90% | 20.17 | 15.00% | 60.00 |
12.38 | 17.54 | 19.65 | 58.75% | 20.17 | 15.00% | 60.00 |
<tbody>
</tbody>
Item Once Dollar amount changes, Item 2 Dollar amount changes ( Base on Product Number ) In this Example Item 2 happens to be the same Product Number so its dollar amount is same in 3 fields... The Idea is to keep all Product numbers to have the same % and $ amounts and then have Item 1's % and $ amounts change to equal the $60 mark.
Anyone have an Idea.. I have tried a few and come up with BIG errors...
As always any assistance is greatly appreciated!!
Thank you!