formula

D

DKULAVIL

Can somebody help me to make a formula for following?
X

a 45
b 15
c 40
d 35
e 60
f 100
g 50

45/a = 15/b = 40/c =35/d= 60/e = 100/f = 50/g = X.
a+b+c+d+e+f+g = 140
How do I find X and a,b,c,d,e,f g
 
F

Frank Kabel

Hi
in Excel I would use the Solver add-in for solving this
equation (or at least get one possible result). Using
solver for your example I got:

X = 2.464285651
 
J

Jerry W. Lewis

Just do a little straightforward algebra, and you will see that this is
just a simple linear equation with exactly one easily obtained solution.

Rearrange to get
b = 15*a/45
similarly, you can express c through g as multiples of a, which will
give you one linear equation in one unkown ...

Since this is almost certainly a homework problem, you will have to work
out the details from here.

Jerry
 
D

Dana DeLouis

I think this is correct. This has 3 Columns. A1:A6 are your numbers with
the range name "rng". Column B are letters. Column C are the formulas.

45 a =(140*A1)/(SUM(rng))
15 b =(C1*A2)/A1
40 c =(C1*A3)/A1
35 d =(C1*A4)/A1
60 e =(C1*A5)/A1
100 f =(C1*A6)/A1
50 g =140 - SUM(C1:C6)
x =SUM(rng)/140

HTH
Dana DeLouis
 
D

Dana DeLouis

Another way would be to use a helper cell like this:

=140/SUM(rng)
or
=140/SUM(A1:A7)

and give it a range name like "t"
Then..

45 a =A1*t
15 b =A2*t
40 c =A3*t
35 d =A4*t
60 e =A5*t
100 f =A6*t
50 g =A7*t
x =1/t

HTH
Dana DeLouis
 
Top