Multiple Nested If Statements

21 replies
7626 views
Translate All

I would like to create a series of nested If statements to calculate kp_figure for Multiple values of Θ (120, 110. 100, 90, 80, 70, 60, and 50), with a secondary If statement for each value of Θ as shown in the calculation for Θ =120.

Any assistance would be appreciated.

1_NestedIfStatements.zip

Mathcad Usage

Werner_EAnswer

25-Diamond I

You have an (implicit) multiplication dot between the 15.15 and the polynomial.

You have to separate the two arguments of the min function by a comma:

Werner_E

25-Diamond I

You don't need an if-statement to calculate the k value. After all its inefficient to calculate the polynomial twice. Let the min-function do the job:

How about defining some functions to do the job?

I was assuming that both, the polynomial and the max value are different dependent on theta. If thats not the case, the solution can be quite simpler. If for instance the polynomial is the very same for all values of theta (and only dependent on Phi.f, you won't need theta and the conditionals in the function "poly" and you also may consider providing the values for theta and the appropriate max-values in vectors and use "Lookup" to chose the correct value instead of the cascaded if's.

Translate

I

idahoan

Author

12-Amethyst

Yes, the maximum value and polynomial are different for each value of theta. I am trying to develop a program/routine to calculate k when the values of theta and phi are changed/entered. I like the efficiency of the min function.

Translate