4
I want to make the following formula but I’m not getting it. I don’t know if it’s with =SE(), but what I need to know is whether a value lies within a range (from 1 to 2) or not.
=SE(A1<=B1>=C1;1;0)
If cell A1 is less than or equal to cell B1 and greater than or equal to cell C1 then it should give 1, if not, it should give 0.
This formula gives error, how do I make it work?
It hasn’t worked out yet. it appears as 0 when it should give 1. The value of A1 is 94,307 (it is an applied formula that can vary as I change my table) but it has to be less than 94,570 or greater than 94,573. When I apply your formula it appears as a false result.
– Thiago
What happens?
– Math
It goes something like this. This formula is part of a system that I’m trying to calculate. I have 30 measurements (each represents an average of another 3 measurements). However these media need to be outside a certain control limit (which is also generated by formula). These limits are at 94,570.... and 94,573.... . Now what I need is to put a formula that points out when this check is outside the control limits or within them. I could kind of understand?
– Thiago
Math thanks for the help!!! I managed to discover another formula that fits based on what you mentioned. Now yes it calculates correctly. = SE(E(A1<B1);1;SE(E(A1>C1);1;0))
– Thiago
Sorry it took so long, I was on lunch break.
– Math
@Thiago I think if I did =SE(E(A1<=B1;A1>=C1);1;0) it would also work. The difference is in the second comparison that I had used B1>=C1, where it should be A1 >= C1
– Math
I tried this formula you mentioned, and it still didn’t work out because he considered both calculations logical at the same time, so he passed the answer to me as false every time. When I separated and made by elimination, he began to calculate right, because now he looks at the first operation separately from the second and can inform me when the element is or is not within the limit. Thank you so much for your help.
– Thiago