Help with xl formula

  reddwarfcrew 12:16 10 Sep 2003


I have the following formula:

c = {y * d * (a+b)} + (z * d)

now if I know what c is, how to I rearrange the formula to find out what y and z are.

PS I know I can use goal seek, but would like to actually re-arrange the formula.


  reddwarfcrew 12:47 10 Sep 2003


I'll try this later.

  reddwarfcrew 14:27 10 Sep 2003

In order to work out y I need to know what z is, but to know what z is I need to know what y is????

  reddwarfcrew 14:42 10 Sep 2003

Y+Z = E

  reddwarfcrew 15:03 10 Sep 2003

c = value after penalty for withdrawal plus interest.

y = savings account a

z = savings account b

d = penalty for withdrawal

a = interest yet yo be paid (only applies to y)

b = additional interest yet yo be paid (only applies to y)

e = total of y+z

Basically, if I wanted to withdrawal £500 from my 2 accounts (split in proportion to y/e and z/e), then how much would I need to withdrawal in total.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Moto G6 Play Review: First Look

iPad 9.7in (2018) review

Comment bloquer les pop-up sur Android ?