Getting #DIV/0!, how to get 0%?
"Jim Thomlinson" wrote:
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%
|