Home

Whats wrong with that line?

%3CLINGO-SUB%20id%3D%22lingo-sub-666323%22%20slang%3D%22en-US%22%3EWhats%20wrong%20with%20that%20line%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666323%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20following%20code%20worked%20fine%20until%20I%20include%20the%20line%20beginning%20with%20%24AV30...%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%24V%2412~%24Z%2412%20cells%20they%20point%20to%20I%20suspect%20are%20the%20problem.%20I%20tried%20to%20find%20arbitrary%20values%20to%20put%20in%20the%20cells%20during%20testing%20but%20code%20returns%20as%20FALSE.%20I%20have%20input%20%220%22%2C%20%220.0001%22%2C%20and%20even%20left%20the%20cells%20empty.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(%3C%2FP%3E%3CP%3EIF(%24D%2420%26gt%3B0%2C%24AB30%26lt%3B%24AC30%2C1)%2C%3CBR%20%2F%3EIF(%24F%2420%26gt%3B0%2C%24AD30%26lt%3B%24AE30%2C1)%2C%3CBR%20%2F%3EIF(%24H%2420%26gt%3B0%2C%24AF30%26lt%3B%24AG30%2C1)%2C%3C%2FP%3E%3CP%3E%24AH30%26lt%3B%24AI30%2C%3CBR%20%2F%3E%24AJ30%26lt%3B%24AK30%2C%3CBR%20%2F%3E%24AL30%26lt%3B%24AM30%2C%3CBR%20%2F%3E%24AN30%26lt%3B%24AO30%2C%3C%2FP%3E%3CP%3E%24AV30%26gt%3B%3D%24V%2412%2C%20%24AW30%26gt%3B%3D%24W%2412%2C%20%24AX30%26gt%3B%3D%24X%2412%2C%20%24AY30%26gt%3B%3D%24Y%2412%2C%20%24AZ30%26gt%3B%3D%24Z%2412%2C%3C%2FP%3E%3CP%3E((%24D%2420%26gt%3B0)%2B(%24F%2420%26gt%3B0)%2B(%24H%2420%26gt%3B0))%3C%2FP%3E%3CP%3E)%2C(%24AV30)%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-666323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666376%22%20slang%3D%22en-US%22%3ERE%3A%20Whats%20wrong%20with%20that%20line%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666376%22%20slang%3D%22en-US%22%3Eformula%20seem%20to%20work%2C%20could%20you%20please%20attach%20the%20file%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666377%22%20slang%3D%22en-US%22%3ERe%3A%20Whats%20wrong%20with%20that%20line%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666377%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20seems%20the%20possible%20result%20of%20your%20formula%20is%20either%20the%20value%20in%20%24AV30%20or%20empty%20text%20(%22%22).%20If%20so%2C%20what%20conditions%20must%20be%20fulfilled%20for%20the%20formula%20to%20return%20the%20value%20of%20%24AV30%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Greg Bonaparte
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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies