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