checking the absolute value of a number

D

Derrick

i have a list of numbers in multiple columns......
A B C D
1 40 -36 MAX abs. Value 1
2 45 -45 MAX abs. Value 2
3 21 -10
4 26 -46
: :

i have to select the largest absolute value from:
1) columns 'b' and 'c', and from the from rows 1, 3, 5,... etc
2) columns 'b' and 'c', and from the from rows 2, 4, 6,... etc

I know how to use the =MAX(cell selection) function:
D1 =MAX(B1:C1, B3:C3,...)

but how do i compare the absolute values so that:
D1 = 40
D2 = 46

my =MAX(cell selection) formula is quite large, so i dont want to do an
=IF(this, then, else) to check to see if it's negative, and then multiply by
-1 if it is, because my formula will be excessively large.

any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top