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

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Maximum Absolute Value from a set of results

ptc-3842272
1-Visitor

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,

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.

MichaelH
12-Amethyst
(To:MichaelH)

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.

Announcements

Top Tags