Divide by zero

[mmccra2858]

I have a spreadsheet that shows a department sumarry.
One cell say B have the number of jobs in house, cell C has the number of jobs at the vendor.
To find the percentage of jobs at the vendor I divide the value in cell C by the value in cell B =sum(c9/b9)
That works great except sometimes for a particular department I may not have any jobs in house or at the vendor, then of corse I get an error #DIV/0!
my qusetion is, is ther a better way to set this up so my users don't see a divide by zero error?

Thanks

Matt

[zbor]

Try:

=IF(B9=0, "", C9/B9)

[Bmoe]

You can use ifError([statement],0) Anytime it picks up an error it will default to 0 (or whatever you put as the second argument)

[royUK]

You can hide it using ISERROR, or check for empty cells with your formula

[Pepe Le Mokko]

Or = IFERROR(C9/B9,"") for post 2003 versions

[zbor]

Or = IFERROR(C9/B9,"") for post 2003 versions

His profile show 2003 version

[Pepe Le Mokko]

His profile show 2003 version

yes it does

[Bmoe]

D'oh I missed 2003. Then yea, probably want to go with the Zbor's answer. I might still suggest putting a 0, or something other than "blank" in, just for aesthetics but it's up to you. Might not be important at all.

[mmccra2858]

It works great, thanks