sum and divide cells and have cells to turn to zero if #div/o! exist

[big0]

I have cells that on occasion turns to #div/o! when dividing by zero. Is there a way on turning #div/o! to zero?

How to re-write the formula to gain zero????

=SUM(B91:E91)/G91

big0

[Jonmo1]

Try

=IF(G91=0,0,SUM(B91:E91)/G91)
or
=IFERROR(SUM(B91:E91)/G91,0)

[big0]

ok. this workes =IF(G91=0,0,SUM(B91:E91)/G91)
but what does the second zero mean? G91=0,0

[Jonmo1]

The 2nd 0 is what the IF function returns if the expression (G91=0) is TRUE.

[big0]

ok. =I understand. Thx for your support

[Jonmo1]

You're welcome.

[big0]

one more ?.....This works =IF(G91=0,0,SUM(B91:E91)/G91), but need the zero to display 00:00, my bad

[Jonmo1]

Format the cell with the formula as a time hh:mm (or mm:ss depending on what your values are..)

[big0]

Yes. all of my cells were formated to mm:ss, prior to using the new formaula. For some reason, it looses its format and post 0.003472222 in lieu of showing mm:ss

big0

[ChemistB]

You need to format that column (that contains the formula) to mm:ss

[Jonmo1]

Change the format of the cell with the formula back to mm:ss

[big0]

OK. It must of been me....it works thx for sticking with me.

[Jonmo1]

You're welcome.