Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
Hello,
i have question about repeating calculating of sheet. I would like to type a program where is important change input according on the result. Example.
a=1,1
X:=some equation
X=6
and it is less than I need, so I need to change the a argument. I need to by it automatically.
Thank you for answer.
Tomáš Martinka
A "solve block" is probably the closest to your request. Look them up.
But for some cases, especially if you have a single equation, the root() function may work just as well.
An example:
So for x=1.165, f(x)=5.
Luc
But saidly i have more complicated case. I am trying to use FEM for calculating of load capacity. So I have load classes and I need change classes automatically when is load from choose class less than allowed load..
It might be challenging to do (it's impossible without seeing the sheet) but you might be able to rewrite your calculation as a function of the input. It would then be possible to execute one or both of the options above.