Need help with multiple nested IF statements...

[Skyler G.]

Thank you all in advance...

The first file shows how the intended equations are to be used and the interpolations needed to derive the values. However, I am trying to create the same information with the ability to pull the information directly from the table (matrix) with the ability to interpolate in both the x and y values, as needed.

What i have up to this point is shown in the second file. I am slowly finding a way to make it work, however I would really appreciate any assistance and also I am assuming their are cleaner ways to accomplish the needed tasks.

 

[Skyler G.]

Second file...

 

[IRstuff]

Your two files appear to be the same file


TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[Skyler G.]

SORRY... here is the first file again... not sure how i did that... and i cant seem to replace it...

FIRST FILE ATTACHED HERE!

 

[Skyler G.]

OK....
I have been able to solve the programming for any number "z" (z is a percentage between 20-100)… now i need to tackle the r_max values.

The first column/row of the matrix are for indexing to the correct value in the table/matrix.

floor(r_max) & ceil(r_max) work as long as the r_max value is 4 and 6... however i need a better way to get it to select the r_max values available to the left or right out of the options in row 0, except zero.

BTW the program returning "ERROR" is just a way i can get it to not work and light up red if someone enters an invalid percentage.

 

[yakpol]

Once upon a time wrote a function for double interpolation for universal usage. In the attached file I placed the table and the arguments from your example. However, this routine will not work with the free MathCad Express.

Yakpol