N
Neil M
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
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