#DIV/0! error:ome of the cells don't have data

[alex1982]

I want to use the following formula, however i keep getting a #DIV/0! error. I know this is because some of the cells don't have data, but is there away to avoid the #DIV/0! error when cells have no data in them?

=(R12/C12)+(S12/A$3)+((I12*Q12)/60)+(T12/H12)

[zbor]

=IF(OR(C12=0;A3=0;H12=0);"Can't divide by zero";(R12/C12)+(S12/A$3)+((I12*Q12)/60)+(T12/H12))

[zbor]

Or this...

=IFERROR((R12/C12)+(S12/A$3)+((I12*Q12)/60)+(T12/H12);"Can't divide by zero")

[DonkeyOte]

Hi zbor, remember that native IFERROR function is not available in versions prior to XL2007 - always best to make this point to the OP if unsure as to which version is in operation.

In the first formula you could also remove the test of Q12 = 0 given it is only if the divisor = 0 that will generate #DIV/0!

[zbor]

True about Q12... didn't look carefully...

Here, one more way

=IF(C12*A3*H12=0;"Can't divide by zero";(R12/C12)+(S12/A$3)+((I12*Q12)/60)+(T12/H12))