Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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!!! |