up vote 1 down vote favorite
share [g+] share [fb]

I'm looking for a function in Excel that looks something like

= MAX(ABS(A1:A10))

Except ABS() doesn't take a range of numbers.

The best that I can come up with is:

= MAX(ABS(MIN(A1:A10),ABS(MAX(A1:A10)))

It does the trick, but it's messy as all heck and I can't believe there's not a better way. Any ideas?

link|improve this question
100% accept rate
feedback

1 Answer

up vote 5 down vote accepted

You must enter it as an array formula. Do so by pressing Ctrl+Shift+Enter. The formula will appear as {=MAX(ABS(A1:A10))} if done correctly.

link|improve this answer
Note to numb-skulls like myself: Enter the formula then press Ctrl+Shift+Enter, I was trying to press ctrl+shift+enter first, then enter the formula, that didn't really work so well. :P – Ben Oct 14 '11 at 19:26
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.