Divide Problems

C

Chris Watson

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 & A2 are blank A3 is showing:
#DIV/0! I want the cell to be blank until I enter data in A1 & A2 is
this possible.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top