I'm getting the #DIV/0! error

  • Thread starter Thread starter Reverand Mooney
  • Start date Start date
R

Reverand Mooney

When I'm calculating for a % I entered the IF formula =IF(B10=0,"",B10/C10)
and it worked ok when B10 was 0 but how would you modify this formula if
either B10 or C10 were 0? The result can display 0 for my purposes.

Thanks.
 
Back
Top