Hi,

Im struggling to write a worksheet to calculate how to come up with a target number using percentages of two other numbers. Obviously I could just goo the long winded way and break the percentages down 1 by 1 and just number crunch through it. But i would like the calculation to be recyclable as in the future all three numbers are likely to change and going through it all again isnt that appealing.

If it helps you imagine it any better the target number is my rent, and the two other numbers are me and my missus salary

Any input would be greatly appreciated as I dont even know where to begin the calculation.