Formula that calculates % variance... but sometimes the divisor is 0

[johnnyrad]

We have sheets set up that get automatic exports from another program..
then in excel its calculating the % variance of 2 numbers. Problem i
sometimes one of the numbers will be a "0", so it shows #div/0!. I
guessing I would use some sort of IF formula... like if its div/0, the
just display 0, otherwise calculate it. We just want it to show 0 fo
presentation purposes... and so it doesnt have to be manually plugge
in each time.

Right now its just a simple =A1/B1 type of deal. Any ideas?

TIA

 

[JulieD]

Hi

=IF(B1=0,0,A1/B1)
should do it

Cheers
JulieD

 

[Frank Kabel]

Hi
try
=IF(OR(B1=0,B1=""),0,A1/B1)

 

[Harald Staff]

=IF(B1=0,0,A1/B1)

HTH. Best wishes Harald