| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on setting up excell to solve a math problem | Excel Worksheet Functions | |||
| need help to solve this | Excel Discussion (Misc queries) | |||
| How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
| Solve Order of a CalculatedField in a Pivot Table | Excel Discussion (Misc queries) | |||
| How do you use solver to solve a polynomial | Excel Discussion (Misc queries) | |||
Hybrid Mode
