Skip to main content
Y
YA_1096379814-Alexandrite
14-Alexandrite
November 19, 2024
Solved

comparing a scalar value to a array

  • November 19, 2024
  • 2 replies
  • 1434 views

Hi there,

I'm trying to compare a result I got as a array to one value .... if the condition is not meet the program should show error >>> it should compare each value in g... to explain it goes to the first row in g which contains a matrix (5*1) and compare the all the numbers in that matrix if it doesn't meet the conditon it writes error ... then goes to the second row in g and do the same 

YA_10963798_0-1732005982204.png

 

this is from the orginal sheet :

YA_10963798_1-1732005852008.png

 

Prime 10 is attached 

 

Best answer by Werner_E
@YA_10963798 wrote:

What I expect is option 3 :  a similar nested 5x1 vector as g but with values below 25 replaced by NaN, "error" . How did you do it 🙂

That way - the local function "replace" is called vectorized for every of the five vectors in g.

Werner_E_0-1732024364140.png

If you need that kind of check more often in the sheet and maybe with different conditions, it may be worth turning it into an appropriate function.

Werner_E_1-1732025664385.png

 

Prime 10 worksheet with all variants attached

 

2 replies

A
AlanStevens19-Tanzanite
19-Tanzanite
November 19, 2024

Here's one possibility:

Verife.png

 

 

    Y
    YA_1096379814-AlexandriteAuthor
    14-Alexandrite
    November 19, 2024

    Can you tell me why did you put verife=0 in your function 

    W
    Werner_E25-Diamond I
    25-Diamond I
    November 19, 2024

    So what do you expect as answer to your demo data set?

    Is it the 25x1 vector which Alan shows or is it rather a 5x1 vector with all "error" because none of the five matrices in g consist of values which ALL are larger than 25?

    Werner_E_1-1732013480413.png

     

    Or, as a third possible interpretation which comes to my mind, do you expect a similar nested 5x1 vector as g but with values below 25 replaced by NaN, "error" or whatever?

     

    So the options as I see it are

    Werner_E_0-1732019915544.png

    Werner_E_1-1732019943226.png

    Werner_E_3-1732019967755.png

     

     

     

     

    Y
    YA_1096379814-AlexandriteAuthor
    14-Alexandrite
    November 19, 2024

    What I expect is option 3 :  a similar nested 5x1 vector as g but with values below 25 replaced by NaN, "error" . How did you do it 🙂

    W
    Werner_E25-Diamond IAnswer
    25-Diamond I
    November 19, 2024
    @YA_10963798 wrote:

    What I expect is option 3 :  a similar nested 5x1 vector as g but with values below 25 replaced by NaN, "error" . How did you do it 🙂

    That way - the local function "replace" is called vectorized for every of the five vectors in g.

    Werner_E_0-1732024364140.png

    If you need that kind of check more often in the sheet and maybe with different conditions, it may be worth turning it into an appropriate function.

    Werner_E_1-1732025664385.png

     

    Prime 10 worksheet with all variants attached

     

    Terms & ConditionsAccessibility statement