#VALUE! - how to get rid of it?

[Guest]

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

 

[Guest]

Try

If(Iserror((CL5-EH5-CL5*0.85*$EY$5-CL5*$EX$5-CL5*0.85*$EU$5)*BZ5),"",(CL5-EH5-CL5*0.85*$EY$5-CL5*$EX$5-CL5*0.85*$EU$5)*BZ5))

 

[Guest]

Hi AKphidelt!

I just tried something different and it also
works!=IF(OR(CM32="",EI32="",$EY$5="",$EX$5="",$EU$5="",CA32=""),"",(CM32-EI32-CM32*0.85*$EY$5-CM32*$EX$5-CM32*0.85*$EU$5)*CA32)

thank you a lot!