If I understand you question correctly, wouldn't the following work for
H1?
=A1/2-(C1+E1+G1)
If B1 is the only item entered, then H1 would equal 2/6 of A1, which
sounds like what you want. Let me know if I'm off track
- Chad
--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile:
http://www.excelforum.com/member.php...o&userid=24380
View this thread:
http://www.excelforum.com/showthread...hreadid=572489