Getting rid of #DIV/0!

S

sirjbean

This is the formula I'm using =sum(E12*100)/F12. If E12 is left
blank with no entry I get #DIV/0!. How can I get rid of that result
without having to put a zero in E12?
 
G

Gord Dibben

Trap for F12 being blank or a zero.

=IF(OR(F12="",F12=0),"",(E12*100)/F12)


Gord Dibben MS Excel MVP
 
N

NateBuckley

Try this formula

=IF(ISERROR((E12*100)/F12),"",(E12*100)/F12)

What you're saying is

IF The Value E12*100 / F12 IS an ERROR then display "" (blank) else
work out the sum and display it.

Hope this works.
 

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

Formula doesn't compute. Can you figure it out? 7
Help with If statement 2
How do I fix this formula? 4
dividing 0 by 0 in excel 2003 10
7+ Nested if Statement using indirect function 6
need a formula for this scenario 10
Changing up to 2 of 3 vals and the 3rd val is automatically Calcul 4
URGENT problem with Autofill in a macro 4

Top