#DIV/0!

[Guest]

Hope you can help me
In the spreadsheet the formula is ie =D283/D190. At this moment all the
figures are zero reason why it is returning #DIV/0!. Some of the cells in the
tables might stay like this for a while. Is there a formula that I could
enter so it doesnt show #DIV/0! but Zero in this cases

 

[Guest]

One way:
=IF(D190=0,0,D283/D190)

 

[Guest]

Try:-=

=IF(ISERROR(D283/D190),"",D283/D190)

Mike

 

[David Biddulph]

=IF(D190=0,0,D283/D190)