I'm getting the #DIV/0! error

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#VALUE! - Error 4
Unique Value Count in 3 Columns Using Search Criteria 0
An AddIn for a custom function 3
Macro Relative Cells 3
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range. 5
If statement based on time ranges 2
Help needed with a formula or macro 1
I hate the DIV/0! error! Can anyone help me make this go away? 5

Top