Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hi, I have this question:
how to get the maximum absolute value from a set of results.
thanks in advance for your help,
Solved! Go to Solution.
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?
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:
Another option: stack them into a vector first
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.