excel help

azamc

azamc

azamc

Associate
Joined
16 Mar 2007
Posts
721
hi,

i need some help with excel. how can i apply an iterative procedure in excel so that the values in red are adjusted so that the values in blue are as small as possible within a given range.

thanks




ocuk2.jpg
 
In B5 cell do "=b5+0.000001"

Or draw a graph

edit: got the wrong end of the stick, didn't notice the blue circles
Do "=j4+0.000001" in J4, and "=J17+0.000001" in J17
Then hold down F9

BTW I'm an amateur, am sure there are better ways.

Also that work looks quite interesting, what's it for?
 
Last edited:
hmmm i dont think that will work, becuase in J4 and J17 i already have formulas on how to get its value.

the work is for and engineering design coursework
 
You may be able to use "Goal Seek" to do this. You can create a sum of J4 and J17, but code in their min and max values to the sum. That gives you one target.

If you can somehow make B3 and B5 formulae relying on 1 cell, you can use Goal Seek to "try" and set the sum of J4 and J17 to 0 by changing the "input" for B3 and B5.
 
Data > What-If Analysis > Goal Seek.

You give it a target cell (Set cell: x), what value you want (as small as possible, so 0 or negative whatever), and then what cell to weak to try and achieve that (By changing cell: y).

So if I have A1 as "0" and B1 as "=A1 + 1", if I Set cell: B1 To Value: 5 By changing cell: A1 and click "OK", very quickly A1 will raise to 4.

Make sense?
 
You must log in or register to reply here.
Back
Top Bottom