Whats wrong with that line?

Iron Contributor

The following code worked fine until I include the line beginning with $AV30...  

The $V$12~$Z$12 cells they point to I suspect are the problem. I tried to find arbitrary values to put in the cells during testing but code returns as FALSE. I have input "0", "0.0001", and even left the cells empty.

 

=IF(AND(

IF($D$20>0,$AB30<$AC30,1),
IF($F$20>0,$AD30<$AE30,1),
IF($H$20>0,$AF30<$AG30,1),

$AH30<$AI30,
$AJ30<$AK30,
$AL30<$AM30,
$AN30<$AO30,

$AV30>=$V$12, $AW30>=$W$12, $AX30>=$X$12, $AY30>=$Y$12, $AZ30>=$Z$12,

(($D$20>0)+($F$20>0)+($H$20>0))

),($AV30),"")

2 Replies
formula seem to work, could you please attach the file?

It seems the possible result of your formula is either the value in $AV30 or empty text (""). If so, what conditions must be fulfilled for the formula to return the value of $AV30?