How do I let a percent formula = 0?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a percent formula when it equals zero to put a zero in the cell. How
do I allow this? Right now I'm getting "#DIV/0!" ?
 
you need to use the iserror function.
EG

=IF(ISERROR(a1/a2*100)=TRUE,0,a1/a2*100)

ie if the answer is #n/a then it will show 0 otherwise it will show the
percentage
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

How do I let a percent formula = 0? 1
Average Formula Help 2
IF Function that returns a percentage 2
Getting #DIV/0!, how to get 0%? 28
#DIV/0! error 1
Forumla for %, i.e. 4 over 0 should equal 400% but get #DIV/0! 6
IF and THEN statements 5
I want to see blank cell rather to see #DIV/0! 4

Back
Top