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

  • Thread starter Thread starter Wee Meng
  • Start date Start date
W

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
 
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
 
-----Original Message-----

I'm just guessing, but

=MAX(ABS(A1:F1))

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

HTH,
Andy
Click to expand...

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
 
-----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
.
Click to expand...

Hi Andy,

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

Cheers
Wee Meng
 
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.
 
Back
Top