How do I let a percent formula = 0?

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

Guest

One of my columns is a percent formula. When the percent equals zero its
putting"#DIV/0!" instead of 0. Iwant the zero to be put in. How do I do this?

David
 
How about this
=if(a1=0;0;b1/a1)

assuming a1 is your cell that might hold a zero-value and =b1/a1 was your
calculation.
 

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
Forumla for %, i.e. 4 over 0 should equal 400% but get #DIV/0! 6
Access My Expression Contains Wrong number of arguments 0
Monthly Percent Increase 1
Help with a range formula 4

Back
Top