How do I let a percent formula = 0?
 

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 do I let a percent formula = 0?
 

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.





"David" skrev i melding
...
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