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.
--
David Biddulph

"David" wrote in message
...
Futher to my message earlier H4 has the following equation:
=IF(AND(F40,G40),"",IF(F40,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