How to avoid #DIV/0 from appearing

  • Thread starter Thread starter Chris921
  • Start date Start date
C

Chris921

Hi - does anyone know how to avoid having #DIV/0 appear on a sheet when
the values it pulls from are empty?

Part 2 - does anyone know how to set the value of all unlocked cells to
zero automatically? Will this help with the #DIV/0 problem I'm dealing
with now? :confused: Thanks to anyone who replies!
 

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

how to hide #DIV/0! 6
#DIV/0! error 1
Zeros and #DIV/0! 5
Conditional Formatting for #DIV/0! 6
I want to see blank cell rather to see #DIV/0! 4
#DIV/0 error 2
How not to display null values (0's and/or #DIV/0!'s? 2
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5

Back
Top