Okay, hopefully this is an easy one. I am trying to write a sheet that
keeps entering different values into a formula until the result of that
formal results in an acceptable answer compared to another value. It's a
stress calculation for plate thicknesses. I want it to try a thickness
(lets say 1/8" or .125) and if that result (a stress) is greater than the
allowable stress it would try the next thickness up. I could live with it
trying values in incriminates (lets say it bumps the value up 0.0313 each
time) or compare it to a chart of known plate thicknesses (1/16", 1/8",
3/16", etc.).

I keep wanting to use the old loop

IF X Y THEN
Z=Z+0.0313

etc.....and have it keep looping around. How is this done in excel.

THANKS!!!

the new "improved" method is Tools, Goal Seek

A1=0.0313
B1=your formula
C1= your reference / target value
D1=b1-c1

Then tools, Goal Seek
Set Cell: D1
to Value: 0
By changing cell: A1

This should then iterate through until it finds a solution


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274556

That's fine in a one time solution. What I am trying to do is have a list
of inputs on "Sheet 1" and have the results calculated on the other 50 or so
sheets. I need to put in the values and have it produce the results
automatically. There are a ton of areas where I would need to use this
feature. I need this to be automated.

Thanks.



"Alex Delamain" wrote in
message ...

the new "improved" method is Tools, Goal Seek

A1=0.0313
B1=your formula
C1= your reference / target value
D1=b1-c1

Then tools, Goal Seek
Set Cell: D1
to Value: 0
By changing cell: A1

This should then iterate through until it finds a solution


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274556

Hi
then Excel is probably not the right tool for this task

--
Regards
Frank Kabel
Frankfurt, Germany

"Jeff Farrar" schrieb im Newsbeitrag
news:dVPhd.560814$8_6.191449@attbi_s04...
That's fine in a one time solution. What I am trying to do is have a
list
of inputs on "Sheet 1" and have the results calculated on the other
50 or so
sheets. I need to put in the values and have it produce the results
automatically. There are a ton of areas where I would need to use
this
feature. I need this to be automated.

Thanks.



"Alex Delamain" wrote in
message ...

the new "improved" method is Tools, Goal Seek

A1=0.0313
B1=your formula
C1= your reference / target value
D1=b1-c1

Then tools, Goal Seek
Set Cell: D1
to Value: 0
By changing cell: A1

This should then iterate through until it finds a solution


--
Alex Delamain

---------------------------------------------------------------------
---
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread:
http://www.excelforum.com/showthread...hreadid=274556