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.


--
chrisabberton
------------------------------------------------------------------------
chrisabberton's Profile: http://www.excelforum.com/member.php...o&userid=16872
View this thread: http://www.excelforum.com/showthread...hreadid=320531