=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?