Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
maximum | Excel Worksheet Functions | |||
Maximum | Excel Worksheet Functions | |||
MAXIMUM VALUE | Excel Worksheet Functions | |||
Specify Maximum Value | Excel Discussion (Misc queries) |