Hi everyone,

I looked through the previous questions and didn't seem to find one that fit
my situation.

I have a simple formula that returns #DIV/0! when there is no data in the
fields E & F. I tried to but zeros in e&f and it still doesn't work.

(E7+F7)/$J$12*$I$5

I tried IF ISNA & IF ISERROR. I get lost with the logic sometimes.

how can I fix this so it just returns zero or blank? The bottom amount maps
to another spreadsheet and it will not calculate correctly the with #DIV/0!
in the total

I really would appreciate your help?