HOW TO FIND MAX NO INCLUDING NEGAITIVE ABSOLUTE NO FROM A RANGE OF CELL

[Wee Meng]

Hi,

Could any kind soul help me on how to determine the
maximum number including negative numbers from range of
cell. For Eg,

A B C D E
1 1 2 -4 -10 5


=> The answer for this should be 10. What formula should
I use for the above to find the maximum? I need an answer
of 10 for this example. I try to use Max(A1:E1)and I get
result of 5 instead of 10.

Appreciate you help.

Thanks
Wee Meng

 

[Andy Brown]

maximum number including negative numbers ...

I'm just guessing, but

=MAX(ABS(A1:F1))

entered as an array (CTRL+Shift+Enter) seems to do it.

HTH,
Andy

 

[WEE MENG]

-----Original Message-----

I'm just guessing, but

=MAX(ABS(A1:F1))

entered as an array (CTRL+Shift+Enter) seems to do it.

HTH,
Andy

Hi Andy,

I tried but Excel return a value of 1. Pls explain in
more detail what do you mean by entered as an array
(CTRL+Shift+Enter) seems to do it.

Thanks,
Wee Meng

 

[WEE MENG]

-----Original Message-----


Hi Andy,

I tried but Excel return a value of 1. Pls explain in
more detail what do you mean by entered as an array
(CTRL+Shift+Enter) seems to do it.

Thanks,
Wee Meng
.

Hi Andy,

I have got it. Thanks a million. Have a nice day!

Cheers
Wee Meng

 

[JE McGimpsey]

Type the formula into the formula bar. Instead of pressing Enter, hold
down both the Shift key and the Ctrl Key, then press enter.

See "About array formulas" in XL Help.