Skip to main content
Y
YA_1096379814-Alexandrite
14-Alexandrite
May 15, 2024
Solved

Eliminate some inputs

  • May 15, 2024
  • 1 reply
  • 1201 views

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

 

    Best answer by Werner_E

    Seems that only two of your six matrices qualify.

    Werner_E_0-1715772994437.png

     

    1 reply

    W
    Werner_E25-Diamond IAnswer
    25-Diamond I
    May 15, 2024

    Seems that only two of your six matrices qualify.

    Werner_E_0-1715772994437.png

     

    Y
    YA_1096379814-AlexandriteAuthor
    14-Alexandrite
    May 15, 2024

    Thank youuuuuuuuuuuuuu soooooooooooooooooooo much 

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

    W
    Werner_E25-Diamond I
    25-Diamond I
    May 15, 2024

    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

      Terms & ConditionsAccessibility statement