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 3
An AddIn for a custom function 3
Macro Relative Cells 3
Help needed with a formula or macro 1
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range. 10
I hate the DIV/0! error! Can anyone help me make this go away? 5
Conditional Formulas In Excel a Challenge 1
For Mike H.'s reply about my msg Jan 20, 'sumif but also filtering 4

Top