Thread: Getting #DIV/0!, how to get 0%?
View Single Post
  #1   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%?
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