Hey guys plz help me

[sm�ller-2]

Im still working on a routine and im stucking in defining a routine for each row of the vector.

I need to define a certain condition and apply it to every row of the vectors

The rows are depending on the Loadcases, which are read in mathcad.

I still dont really understand 😞

Thx 😃

In this case i need to write the maximum value of the calculated 5 pressures to excel for every loadcase.

[Werner_E]

You didn't attach tha datafile so we just see errors in your sheet.

Could it be that you are looking for something like this:

[sm�ller-2]

yes best thx mm having little problems with the notation so far.

I hope i can make a workaround and get rid with the "NaN" values.

[Werner_E]

yes best thx mm having little problems with the notation so far.

???

I hope i can make a workaround and get rid with the "NaN" values.

? To what extent does this have to do with your original question here?

[sm�ller-2]

hmm i was only meaning sometimes i dont know how to write the condition and that stuff because i dont know the exact programmcode.

I could manage to read out the maximal pressure with your help but today i was occuring the Problem that a variable for calculating the pressure is NaN.

I was trying to write a if condition with IsNaN to set the variable from NaN to a certain value, so that i can calculate the pressure and i dont get an error.

Or to exclude for example pT3 if there is a NaN failure.

I also tryed the function "on error". MMM

I was thinking the if condition to set a variable to a defined value if NaN occurs would work faster.

[Werner_E]

NaN's are treated as 0's by the "max" function. So they will only be a problem if the rest of the five values all are negative.

[sm�ller-2]

I could happyly manage it. I want to share it with you how i solved it:

As you can see i have 5 pressures now i wrote for the pressure formula:

pt1=0 on error 5*b/x   (with all pTs)

with p=5*b/x

so i can manage the problem, when i have only pT1 and all others are without value.

I can then make the max(pT1,pT2,pT3,pT4,pT5) without an error when only 1 or 2 pT is available to calculate the max

=))