View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christy Christy is offline
external usenet poster
 
Posts: 89
Default don't show #DIV/0 error in cell

I'm using the following formula, which is GREAT, but I would like to alter it
to when Col F & Col C are 0 there is not #DIV/0 shown in the cell.
=SUMIF(F13:F51,"IN",C13:C5)/COUNTIF(F13:F51,"IN")

Same thing for the formula =IF(M3=0,"",+M3/K7*100) or =INT(K1)
Again, GREAT formulas, but when M3 and K7 are both 0, I'd like no error
message in cell as well as when K1 is 0

This is probably a very easy fix, I just can't get it right. Thanks in
advance.
Christy