Help with xl formula

  reddwarfcrew 12:16 10 Sep 03
Locked

Hi,

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.

Cheers.

  reddwarfcrew 12:47 10 Sep 03

Thanks.

I'll try this later.

  reddwarfcrew 14:27 10 Sep 03

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 03

Y+Z = E

  reddwarfcrew 15:03 10 Sep 03

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.

iPhone 7 review: a range of small updates add up to an excellent phone

1995-2015: How technology has changed the world in 20 years

How New York’s Stylin’ Seniors became a golden social media campaign

23 Apple Watch tips & secret features: Master your Apple Watch, Apple Watch Series 1 or Apple…