Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Lookup Function Problems | Excel Worksheet Functions | |||
How to overcome LOOKUP function problems? | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |