Maximum value
 

hei,
I have a table like:
Fx Fy Fz
1 -1975 -3211 -1321
2 781 -5419 1175
3 1431 1270 -4184
4 -8191 6251 -6000

I need to have an answer for the maximum absolut value with keeping the
sight if it is negative.
Like:
Max (+/-) -8191 6251 -6000

is it possible?

Maximum value
 

"Masha" wrote:
I need to have an answer for the maximum absolut value with
keeping the [sign] if it is negative.

There might be something more clever, but try:

=IF(ABS(MIN(A1:A4)) MAX(A1:A4), MIN(A1:A4), MAX(A1:A4))

Note: If both the min and max are the same magnitude (e.g. -6000 and 6000),
that formula returns the positive number. If you would prefer the negative
number, change "" to "=".


----- original message -----

"Masha" wrote in message
...
hei,
I have a table like:
Fx Fy Fz
1 -1975 -3211 -1321
2 781 -5419 1175
3 1431 1270 -4184
4 -8191 6251 -6000

I need to have an answer for the maximum absolut value with keeping the
sight if it is negative.
Like:
Max (+/-) -8191 6251 -6000

is it possible?

Maximum value
 

=IF(ABS(MIN(B1:B4))MAX(B1:B4),MIN(B1:B4),MAX(B1:B 4))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Masha" wrote in message
...
hei,
I have a table like:
Fx Fy Fz
1 -1975 -3211 -1321
2 781 -5419 1175
3 1431 1270 -4184
4 -8191 6251 -6000

I need to have an answer for the maximum absolut value with keeping the
sight if it is negative.
Like:
Max (+/-) -8191 6251 -6000

is it possible?

Maximum value
 

One way of doing it:
=IF(MAX(B2:B5)-MIN(B2:B5),MAX(B2:B5),MIN(B2:B5))
--
David Biddulph

"Masha" wrote in message
...
hei,
I have a table like:
Fx Fy Fz
1 -1975 -3211 -1321
2 781 -5419 1175
3 1431 1270 -4184
4 -8191 6251 -6000

I need to have an answer for the maximum absolut value with keeping the
sight if it is negative.
Like:
Max (+/-) -8191 6251 -6000

is it possible?

Maximum value
 

Another way

(array entered.)
=INDEX(H1:H100,MIN(IF(ABS(H1:H100)=MAX(ABS(H1:H100 )),ROW(H1:H100))))

If this post helps click Yes
---------------
Jacob Skaria


"Masha" wrote:

hei,
I have a table like:
Fx Fy Fz
1 -1975 -3211 -1321
2 781 -5419 1175
3 1431 1270 -4184
4 -8191 6251 -6000

I need to have an answer for the maximum absolut value with keeping the
sight if it is negative.
Like:
Max (+/-) -8191 6251 -6000

is it possible?