=IF(OR(I4=0,J4=""),0,IF(J4="EF Vert",F4/I4,0)+IF(J4="EW EF",F4/I4,0))


--
__________________________________
HTH

Bob

"Neil M" wrote in message
...
I have a sheet with hudreds of cells with the similar formula as follows:

IF(J4="EF Vert",((F4/I4)),0)+IF(J4="EW EF",((F4/I4)),0))

The formula works okay unless J4 is blank then I get DIV/O Error in
several
cells and it affects the last cell that totals numbers.

I have modified the formula to read as follows:

IF(ISERROR(IF(J4="EF Vert",((F4/I4)),0)+IF(J4="EW
EF",((F4/I4)),0)),0,IF(J4="EF Vert",((F4/I4)),0)+IF(J4="EW
EF",((F4/I4)),0))

This also works, but it is very tiresome to have to change hundreds of
cells
at this point.

QUESTION:
Is there an easier way to do this by formatting all the cells or the
entire
sheet in any way?

THanks,
Neil M