View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacq Jacq is offline
external usenet poster
 
Posts: 8
Default Divide by zero error

Whenever I use the below formula, I get a divide by zero error if one of the
numbers it uses is zero. Can someone tell me how to adjust the below formula
to make it display zero instead of the divide by zero error?

=((C13/C10)-E13)/((SQRT(E13*((1-E13)/C10)))*(SQRT(1-F10)))

Thanks