Hide empty field error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
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
 
You must log in or register to reply here.

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

Similar Threads

problem with number format with 2 decimals? 5
#DIV/0! ERROR 2
Average formula 4
Clear Cell If Function = 0 4
Divide Problems 1
dividing by 0 error 6
Adding error suppression to AVERAGE FUNCTION 3
Averaging a column that contains text 4

Back
Top