Need help with a formula

[johnsonbp]

Okay. I am just going totally blank on how to do this. I have create
two sales statistics worksheets recently. In the cells where I have
formula it always shows the following: #DIV/0!

Now, if there is data in the cells, then I get the calculation but i
there is no data to calculate that is when I see the #DIV/0!.

Is there any easy way to get rid of this?

Thanks so much in advance.

Pa

 

[Jason Morin]

One way:

=IF(ISERROR(your_formula),"",your_formula)

HTH
Jason
Atlanta, GA

 

[johnsonbp]

Thank you, thank you!!

I knew it had to be something simple. I appreciate your time i
helping me out.

Have a great day!

Patrici

 

[JE McGimpsey]

One way:

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