Jun 03 2019 11:02 PM
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),"")
Jun 04 2019 12:10 AM
Jun 04 2019 12:11 AM - edited Jun 04 2019 12:37 AM
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?