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

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. 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

 

ACCEPTED SOLUTION

Accepted Solutions
Werner_E
25-Diamond I
(To:YA_10963798)

Seems that only two of your six matrices qualify.

Werner_E_0-1715772994437.png

 

View solution in original post

3 REPLIES 3
Werner_E
25-Diamond I
(To:YA_10963798)

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?

Werner_E
25-Diamond I
(To:YA_10963798)

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

Announcements

Top Tags