Formula Excel with incorrect result

Navigation
3

I have the following formula: 

=SE(1,5*Q2>F8<2*Q2;"RUIM";"BOM")

In Q2 I have 44 and in F8 I have 70 and my result gives BOM . Where is the error?

    
asked by anonymous 07.11.2017 / 18:02

1 answer

3

You will need to use the E next to the function SE ;

SE the value of F8 (70) is greater than 66% with% less than 88, then it will be "BAD", otherwise "GOOD."

The formula will be: 

=SE(E(F8>1,5*Q2; F8<2*Q2);"RUIM";"BOM")

Detail

When working with interval, consider whether to include the reference values themselves - the extremes

See: 

70 > 66 = VERDADEIRO  
66 > 66 = FALSO

If in your worksheet the value of F8 is 66, then you will not enter into the concept of "BAD";

Formula for range (including extremes) 

=SE(E(F8>=1,5*Q2; F8<=2*Q2);"RUIM";"BOM")

wiki
"In mathematics, a (real) interval is a set that contains each real number between two indicated extremes, whether or not it can contain the ends themselves."

    
07.11.2017 / 18:44
Button next to text bar with Bootstrap Alternative to JPA Implementation