Thread: Getting #DIV/0!, how to get 0%?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Getting #DIV/0!, how to get 0%?
Check e34 prior to dividing.

if(e34 = 0, 0,(E34-D34)/E34)
--
HTH...

Jim Thomlinson


"pgarcia" wrote:

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%
Reply With QuoteReply With Quote