Thread: Getting #DIV/0!, how to get 0%?
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
www.memory4less.net www.memory4less.net is offline
Banned
  
Posts: 1
Default Getting #DIV/0!, how to get 0%?
You can pass the 0 as value.


"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