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

Maximum Absolute Value from a set of results

ptc-3842272
1-Newbie

Maximum Absolute Value from a set of results

Hi, I have this question:

how to get the maximum absolute value from a set of results.

thanks in advance for your help,

1 ACCEPTED SOLUTION

Accepted Solutions

You need to use "Absolute Value" operator:

Pic_1.PNG

View solution in original post

9 REPLIES 9

Attaching your worksheet using the advanced editor (see the upper right-hand area of the normal editor) will help people see what you are doing. I strongly suggest you do this.

Have you tried the max() function?

RichardJ
19-Tanzanite
(To:ptc-3842272)

Does this help?

My situation is:

I have these values o results

A:= 25

B:=-55

C:=54

I need to extratc the maximum absolute value from (A,B and C), in this case is 55

Doesn't "max(max(A,B,C),-min(A,B,C))=" work??

It should.

You need to use "Absolute Value" operator:

Pic_1.PNG

RichardJ
19-Tanzanite
(To:ptc-3842272)

Another option: stack them into a vector first

maxabs.jpg

If you have a large number of values this version probably minimizes the typing required

Thank you very much for all your answers,

I'm good now.

You're welcome.

Top Tags