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?

Trap for F12 being blank or a zero.

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


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 19:37:17 -0700 (PDT), wrote:

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?

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.

" wrote:

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?