cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

Eliminate some inputs

YA_10963798
11-Garnet

Eliminate some inputs

Hi there, 

 

we have so many inputs I need to write a program to tell mathcad , if the input matrix or table has less than 700 rows don't include it in the calculation. Can you help me doing this , please? The sheet is attached . 

For example I don't want Mathcad to do the calculation for CPT3 because it has less rows than 700

YA_10963798_0-1715769045082.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Seems that only two of your six matrices qualify.

Werner_E_0-1715772994437.png

 

View solution in original post

3 REPLIES 3

Seems that only two of your six matrices qualify.

Werner_E_0-1715772994437.png

 

Thank youuuuuuuuuuuuuu soooooooooooooooooooo much 

What does (Nan) mean? is it constant or variable?

NaN ("Not-a-Number")is a predefined constant.

Its the result you get if none of the matrices qualify because they all have less than 700 rows.

-> About the NaN (Not a Number) Built-In Constant

Top Tags