On Wed, 30 Jul 2008 08:53:00 -0700, Roy Gudgeon
wrote:

thanks for replies
but am still having probs showing 0 rather than DIV/0


But you wrote "I have been trying to .... resolve this to report 0".

That gave me the impression that you acually wanted to
have 0 as the result when both F5 and G5 are 0.

What result do you want in that case?

Try this:

=IF(AND(F5=0,G5=0), state here what you want, IF(G55,F5/G5,G5/F5))

if you want DIV/0 error, this will give one

=IF(AND(F5=0,G5=0), 1/0, IF(G55, F5/G5, G5/F5))

Hope this helps / Lars-Åke