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)
<!--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,
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,