Skip to main content
P
ptc-38422721-Visitor
1-Visitor
March 3, 2013
Solved

Maximum Absolute Value from a set of results

  • March 3, 2013
  • 2 replies
  • 7581 views

Hi, I have this question:

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

thanks in advance for your help,

Best answer by VladimirN

You need to use "Absolute Value" operator:

Pic_1.PNG

2 replies

M
MichaelH1-Visitor
1-Visitor
March 3, 2013

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.

M
MichaelH1-Visitor
1-Visitor
March 3, 2013

Have you tried the max() function?

R
RichardJ19-Tanzanite
19-Tanzanite
March 3, 2013

Does this help?

P
ptc-38422721-VisitorAuthor
1-Visitor
March 3, 2013

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

M
MichaelH1-Visitor
1-Visitor
March 3, 2013

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

It should.

Terms & ConditionsAccessibility statement