software

I have put together a work sheet which involves fuel consumption on a
vehicle. In cell A1 is the total miles travelled, in cell A2 is the
fuel used (Gallons), in cell A3 I have put in the formula: =A1/A2 which
gives me the result I want but when A1 amp; A2 are blank A3 is showing:
#DIV/0! I want the cell to be blank until I enter data in A1 amp; A2 is
this possible.--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: www.excelforum.com/member.php...foamp;userid=4700
View this thread: www.excelforum.com/showthread...hreadid=511055try
=if(len(a2)gt;1,formula,quot;quot;)

--
Don Guillett
SalesAid Software

quot;Chris Watsonquot; gt;
wrote in message
news:Chris.Watson.230qhp_1139583303.6169@excelforu m-nospam.com...
gt;
gt; I have put together a work sheet which involves fuel consumption on a
gt; vehicle. In cell A1 is the total miles travelled, in cell A2 is the
gt; fuel used (Gallons), in cell A3 I have put in the formula: =A1/A2 which
gt; gives me the result I want but when A1 amp; A2 are blank A3 is showing:
gt; #DIV/0! I want the cell to be blank until I enter data in A1 amp; A2 is
gt; this possible.
gt;
gt;
gt; --
gt; Chris Watson
gt; ------------------------------------------------------------------------
gt; Chris Watson's Profile:
gt; www.excelforum.com/member.php...foamp;userid=4700
gt; View this thread: www.excelforum.com/showthread...hreadid=511055
gt;