Hi Excel Forum,
I am hoping someone can assist me.
I am trying to split the total sum (Cell J13) proportionally according to the % of the individual costs (column E) & also the Duty % (Column H).
I have tried to do this by using the % value (column F) and it will work providing the % values are all the same in (column H)
The problem is when the % values are not the same in (column H)
I have tried to use the % values (column M) from the data in (Column F & I) the total sum is correct but the duty cost % split per item is not correct.
Could some one assist in how I can factor in the Duty % (Column H) to the formula in (column K) or what needs to be changed in the formula in (column M) in order to split the costs proportionally to each item according to the item value & duty %.
I have attached the file which is only currently using the Total price % split (column F) to calculate the split.
Apologizes in advance if I've not done something correctly on this post as this is my first post.
Thank you in advance.
Ian
Bookmarks