Try:

=IF(G3=0,0,AM3/G3)

Note: no need for the SUM() function.

or:

=IF(G3=0,"",AM3/G3)

To return an empty looking cell instead of a zero.

If there is any chance that G3 may contain an empty string, (from a formula)
then use:

=IF(OR(G3=0,G3=""),"",AM3/G3)

HTH

Sandy

In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Peter" wrote in message
...
I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it
gives me a #div!