Hi ...

I'm trying to write a formula in excel

first column has some data with fixed $ values and all other values are -20.
second and third coulumns have $ values.

if column one contains fixed value other than -20 this supercedes col 2 and
3 always.
if column 3 less than column 2 and column one not fixed (=-20) then column
3, else column 2.

ex:

col 1 col 2 col 3
10 (F) 10 8
-20 10
-20 15 12

So I want a column 4 to choose column 1 as answer where col 1 contains fixed
value. if not then choose lesser of 2 and 3 or two in the case where 2 is
the only col w a value.

Please help!!!! Thanks in advance.

--
Thanks!