Association condition E as formatting between numerical intervals

0

I would like a tip on how to make the equation feasible below:

=SE(E($Q1744=W10;8>=$R1744<=12,99);1;0)
    
asked by anonymous 26.03.2017 / 17:59

1 answer

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)
    
26.03.2017 / 23:51