Forum Discussion
Whats wrong with that line?
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 ...
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?