Function to lookup largest value
to get the largest sign irrespective of sign
=MAX(ABS(A1:A20))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"ianthow" wrote in message
...
I am looking for a fucntion to lookup the largest value in a bunch of
cells
(disregarding whether the value is +ve or -ve) then use the largest value
with its sign (+ve or -ve) and multiply by another cell.
Example:
Value 1 = 34
Value 2 = -38
Value 3 = 0
Value 4 = 12
Value A = 10
Value B = -380
The largest value disregarding the sign is -38 which is Value 2, Value 2
is
then required to multiply by Value 5 which is 10 to get Value 6
which -380.
Thanks in advance!
|