How to avoid #DIV/0 from appearing

[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? Thanks to anyone who replies!

[Niek Otten]

Example: =A1/B1

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

--
Kind regards,

Niek Otten

"Chris921" <[email protected]> wrote in
message news:[email protected]...
>
> 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? 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
>