excel help

azamc · 20 Nov 2009 at 17:36

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

azamc · 20 Nov 2009 at 18:31

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

azamc · 20 Nov 2009 at 19:27

hi, can you walk me through how to do this goal seek?
thanks

azamc · 20 Nov 2009 at 21:31

hi,

this doesnt seem to work. i think its becuase the value will never actually get to zero.

any other ideas?

azamc · 21 Nov 2009 at 00:52

hi

heres the link

http://rapidshare.com/files/309905128/impellor_12.xlsx.html