Cell Value must be zero

[Codeman]

When a cell is showing; #VALUE!
Because the amount has not been calculated how can I get it to just show
zero (0)

I am getting the value from other spreadsheets totals and when those totals
are not completed, because they are not applicable, I would like the final
tabulation worksheet to just put 0 automatically there. I do not want to
change the other worksheets from where the totals area coming from.

=SUM('Other Occupancies'!C13) is the formula in one of the cells on my last
spreadsheet and I want it to be showing zero (0) instead of #VALUE!

Can it be done to just show 0 (zero)?

 

[Niek Otten]

=IF(ISERROR(SUM('Other Occupancies'!C13)),0,SUM('Other Occupancies'!C13))

 

[Shane Devenshire]

Hi,

Why not just

=IF(ISERR('Other Occupancies'!C13),0,'Other Occupancies'!C13)

or in 2007

=IFERROR('Other Occupancies'!C13,0)

 

[Niek Otten]

Absolutely right, Shane! I just didn't even notice the
SUMs..................

 

[Codeman]

Thank you, It worked and is shorter.

Hi,

Why not just

=IF(ISERR('Other Occupancies'!C13),0,'Other Occupancies'!C13)

or in 2007

=IFERROR('Other Occupancies'!C13,0)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire