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

Although I don't like Excel 2007....

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

--
Dana DeLouis


"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%