LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jeff Farrar
 
Posts: n/a
Default If..then quesiton.

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"