Multiple IF formula

[Summer07]

Hi,

I am trying to find a formula that works for the following:

=if(A2>0,A1), if(B2>0,B2), if(C2>0,C1), if(D2>0,D1)

	A	B	C	D
1	50	60	70	80
2	$-	$-	$59.00	$-

<!--StartFragment--> <colgroup><col width="14"> <col width="40" span="2"> <col width="52"> <col width="40"> </colgroup><tbody>
<!--EndFragment--></tbody>

Only one A, B, C or D will have a $ value and I need the line 1 information.

Can anyone help me?

Thanks,

 

[T. Valko]

Assuming the $- is a format for number 0.

=LOOKUP(2,1/(A2:D2>0),A1:D1)

 

[Summer07]

Thank you!

Assuming the $- is a format for number 0.

=LOOKUP(2,1/(A2:D2>0),A1:D1)

 

[T. Valko]

You're welcome!