View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ianthow
 
Posts: n/a
Default Function to lookup largest value

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!