If..then quesiton.

[Jeff Farrar]

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!!!

 

[Alex Delamain]

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

 

[Jeff Farrar]

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.

 

[Frank Kabel]

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