Nevermind. I found a macro that fixed my problems.

"kk" wrote:

Hi J

Please try

=If(IsError(YourFormula),"",YourFormula)


"J" wrote in message
...
I am trying to make a simple template to track fuel mileage.
How can I insert the formula into lots of rows and not get the "DIV/0!"
error until numbers are entered in the proper cells? (I don't want anything
to be displayed)