I would like a tip on how to make the equation feasible below:
=SE(E($Q1744=W10;8>=$R1744<=12,99);1;0)
I would like a tip on how to make the equation feasible below:
=SE(E($Q1744=W10;8>=$R1744<=12,99);1;0)
Reevaluate the second logical argument of the function =E
([ 8>=$R1744<=12,99]
). If we separate into 2 separate equations we have:
R1744 <= 8
R1744 <= 12,99
Half redundant, do not you think? But maybe you want to say it's a number between 8 and 12.99 ([ 8<=$R1744<=12,99]
]). Either way, separate the logical terms, like this:
=SE(E($Q1744=W10;8<=$R1744;$R1744<=12,99);1;0)