#Div/0!

[Guest]

Futher to my message earlier H4 has the following equation:
=IF(AND(F4>0,G4>0),"",IF(F4>0,PI()*E4/(6.5*F4),PI()*E4/G4))
Values E,F,G are all input.
How do i get the cell H to display 0 when E equals zero

 

[Guest]

Trying to find which other post to look in was a bit of a nightmare because
you have so many on the same subject. However, I assume in this one you are
trying to eliminate the division/0 error in which case it has nothing to do
with E, it occurs when both F&G=0 so try this:-

=IF(AND(F4>0,G4>0),"",IF(AND(F4=0,G4=0),"",IF(F4>0,PI()*E4/(6.5*F4),PI()*E4/G4)))

Mike

 

[Rick Rothstein \(MVP - VB\)]

Futher to my message earlier H4 has the following equation:

=IF(AND(F4>0,G4>0),"",IF(F4>0,PI()*E4/(6.5*F4),PI()*E4/G4))
Values E,F,G are all input.
How do i get the cell H to display 0 when E equals zero

Unless I am missing something, based on the above equation, it looks like H4
will always be zero whenever E4 is zero since E4. What are you seeing that
prompted you to ask the question that you did?

Rick

 

[David Biddulph]

The only way you would get a divide by zero is if F4 and G4 are both zero
(and in that case you wouldn't have got to that point if you had used some
of the answers to some of your earlier questions). You could protect for
that in the same way you have against F4 being zero (or by one of the
earlier suggestions), or you could test specifically for E4 being zero.