Struggling with a formula if any body could help please?
What I need is a formula for cells B7, B8 & B7 and the criteria is as follows:
Values in these cells needs to be the percentage of the values in B3, B4 & B5 respectively, which is the easy bit. The total sum of cells B7, B8 & B7 must not exceed 100% of the value of cell B1.
Also if the sum of cells B3, B4 & B5 add to less than 100% then cells B7, B8 & B7 still need to total B1.
So in summary B7, B8 & B7 always need to add up to B1 but split by the percentages of B3, B4 & B5, which can be under or over 100%.
Thanks to whoever accepts the challenge!!