G
Guest
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%
percent. Thanks
=(E34-D34)/E34
E34 = 0
D34 = 0
Result should be 0%
Jim Thomlinson said:Check e34 prior to dividing.
if(e34 = 0, 0,(E34-D34)/E34)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.