How to avoid #DIV/0 from appearing
 

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!


--
Chris921
------------------------------------------------------------------------
Chris921's Profile: http://www.excelforum.com/member.php...o&userid=32040
View this thread: http://www.excelforum.com/showthread...hreadid=517880

How to avoid #DIV/0 from appearing
 

Example: =A1/B1

=IF(B1=0,"",A1/B1)

--
Kind regards,

Niek Otten

"Chris921" wrote in
message ...

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!


--
Chris921
------------------------------------------------------------------------
Chris921's Profile:
http://www.excelforum.com/member.php...o&userid=32040
View this thread: http://www.excelforum.com/showthread...hreadid=517880