If I do have a main formula which looks like this:
=(CL5-EH5-CL5*0.85*$EY$5-CL5*$EX$5-CL5*0.85*$EU$5)*BZ5

and the variables are based on the formula for instance:
(IF(ISERR(BZ5*CL5),"",BZ5*CL5/1000)).

How can I adjust the main formula, so it will not return #VALUE!, when one
of the variables of this fomrula is empty due to its initial formula. I just
need to make a point that I do need the initial variables to return empty not
zero.

Would anyone be able to help?

Plzzz :)