Adding a simple linear equation

  • Thread starter Thread starter wjsubs
  • Start date Start date
W

wjsubs

As sad as it is, this is a little out of my league. I am trying t
create an equation in my worksheet that will automatically calculat
the inputs to a sum that will not change.

I want to be able to change the independent variable x, and have th
dependent variable y change accordingly.

I know this is probably a little basic for most users, but any hel
would be appreciated.

The basic setup would be x+y= 240,000 or something similar.

Thank
 
Input your variable x into cell A1.
In B1 put the formula :-
= 240000 - A
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Terms from simple linear equation 4
Evaluate Equation in VBA 3
Linking the Regression equation of a line to a table 1
solving of linear equation 5
Excel Excel 2003 Trend Equation Error 1
Linear Equations 2
Repeated application of Solver to new equations 7
forecast using a four parameter logistic equation 2

Back
Top