Formulas

Hello Elizabeth

Thank you for your question and welcome to the forum.

You can use an IF function in the cell/s where you are putting the formula which is doing the division for you, to prevent the #DIV/0! error appearing.

Say for example that you have the following formula in cell C1:
=A1/B1

and cell B1 contains 0.

By changing the formula as follows, you can stop the #DIV/0! error appearing in cell C1 and have a 0 appear instead:

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

which means:
if the value in cell B1 is zero, display zero in cell C1, otherwise display the result of dividing A1 by B1 in cell C1.

I hope this helps.

Kind regards
Amanda