View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default Getting #DIV/0!, how to get 0%?

thanks

"Peo Sjoblom" wrote:

=IF(E34=0,0,(E34-D34)/E34)

--


Regards,


Peo Sjoblom



"pgarcia" wrote in message
...
I'm getting #DIV/0! with the following formula, the cell is format as a
percent. Thanks

=(E34-D34)/E34
E34 = 0
D34 = 0
Result should be 0%