muddan

ISERROR will hide all errors and would also hide a #VALUE! error if G3 contained
a <space

OP wants just the #DIV0! trapped.

See Sandy's suggestions.


Gord Dibben MS Excel MVP


On Sun, 1 Jun 2008 12:02:42 -0700 (PDT), muddan madhu
wrote:

try this =IF(ISERROR(SUM(AM3/G3)),0,SUM(AM3/G3))

On Jun 1, 11:48*pm, Peter wrote:
I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it
gives me a #div!