How do I solve for x?
 

I have a spreadsheet where O=the sum of A2 through M2. How do I solve for M2
when O2 must = $1mil or less?
Much appreciative of any help!

How do I solve for x?
 

Use the Solver tool. Tools--Solver
--
Brevity is the soul of wit.


"JoAnna" wrote:

I have a spreadsheet where O=the sum of A2 through M2. How do I solve for M2
when O2 must = $1mil or less?
Much appreciative of any help!

How do I solve for x?
 

JoAnna,

Well, I don't think your problem is well constructed (perhaps I'm missing something....), but try
this formula in M2:

=1,000,000 - SUM(A2:L2)

Then the formula in O2

=SUM(A2:M2)

will always equal 1,000,000.

HTH,
Bernie
MS Excel MVP


"JoAnna" wrote in message
...
I have a spreadsheet where O=the sum of A2 through M2. How do I solve for M2
when O2 must = $1mil or less?
Much appreciative of any help!

How do I solve for x?
 

M2 = 100000-SUM(A2:L2) ?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JoAnna" wrote in message
...
I have a spreadsheet where O=the sum of A2 through M2. How do I solve for
M2
when O2 must = $1mil or less?
Much appreciative of any help!

How do I solve for x?
 

M2=1000000-SUM(A2:L2)
--
Gary''s Student
gsnu200702


"JoAnna" wrote:

I have a spreadsheet where O=the sum of A2 through M2. How do I solve for M2
when O2 must = $1mil or less?
Much appreciative of any help!