software

i want to create cell A3 with a calculation that forces a defualt value
into cell B3 if cell B3 is blank, but then that value can be overwitten
by the user without affecting cell A3...possible?--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: www.excelforum.com/member.php...oamp;userid=32268
View this thread: www.excelforum.com/showthread...hreadid=521146Enter =A3 in cell B3.

B3 will pick up whatever A3 has in it. The user can over-ride B3 with any
entry and not affect A3.
--
Gary's Studentquot;bcamp1973quot; wrote:

gt;
gt; i want to create cell A3 with a calculation that forces a defualt value
gt; into cell B3 if cell B3 is blank, but then that value can be overwitten
gt; by the user without affecting cell A3...possible?
gt;
gt;
gt; --
gt; bcamp1973
gt; ------------------------------------------------------------------------
gt; bcamp1973's Profile: www.excelforum.com/member.php...oamp;userid=32268
gt; View this thread: www.excelforum.com/showthread...hreadid=521146
gt;
gt;