Does this do what you want?

=IF(A1<=0,"",IF(B1<"",B1,IF(C1<"",C1,D1)))


On Fri, 26 Nov 2004 03:16:35 -0600, chrisabberton
wrote:


anyone fancy trying to solve an excel problem for me ?

i have 5 cells in a row.

A B C D Z

if there is a value in A and a value in B, then B should appear in Z.

if there is a value in A, no value in B, then C should appear in Z.

likewise if not B or C, then D should appear in Z.

For a value to be displayed in Z, A must be greater than 0.