#VALUE! - how to get rid of it?
 

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 :)

#VALUE! - how to get rid of it?
 

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))

"Claudia" wrote:

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 :)

#VALUE! - how to get rid of it?
 

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!

"AKphidelt" wrote:

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))

"Claudia" wrote:

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 :)