If you can live with circular references until the values are entered:

Cell A2:
=B2+C2

Cell B2:
=A2+C2

Cell C2:
=A2-B2

Copy formulae down


Otherwise separate the input area (A2:C100) and the output area
(D2:D100)

Cell D2:
=IF(COUNTA(A2:C2)<2,"",IF(A2="",B2+C2,A2))

Cell E2:
=IF(COUNTA(A2:C2)<2,"",IF(B2="",A2+C2,B2))

Cell F2:
=IF(COUNTA(A2:C2)<2,"",IF(C2="",A2-B2,C2))

Copy formulae down


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534014