Hide empty field error

J

J

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)
 
K

kk

Hi J

Please try

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


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)
 
J

J

How can I mass populate this to change for every row?
e.g. a1 divided by c1 solution goes in d1(this is where I use the formula)

:a
 
Top