View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beep Beep Beep Beep is offline
external usenet poster
 
Posts: 101
Default Make zero formula

I am getting the below message with the formula showing.

#DIV/0!
=I11/E11*1000*5

Can you tell me how to put the -iserror formula to make this show zero if
the cells are zero..

Thanks
Frank