How do I let a percent formula = 0?

D

David

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
 
K

Kjetil

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.
 
Top