iferror
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
|