JerryMason
New Member
- Joined
- Jun 2, 2022
- Messages
- 7
- Office Version
- 365
Hey everyone,
I have another interesting problem I can't find the answer to (exactly).
I have a value in Column A (we'll call it value A) and with a single formula I'd like to try and be able to compare it to 6 other values in cells adjacent to it (Columns B, C, D, E, F, G) and in Column H we have a formula tell us if A is:
Below B = 0
Between B and C = 1
Between C and D = 2
Between D and E = 3
Between E and F = 4
Between F and G = 5
Above G = 6
For example if A = 21 and the comparison values are ------->>> 3 | 17 | 24 | 29 | 38 | 51
The formula in H will return a "2"
*All values from B to G are sequential counting upwards, nothing is out of order.
I've tried this with two values (some form of an if(and) ) but now I'm at a loss with up to six. Is there a way to do this even?
I have another interesting problem I can't find the answer to (exactly).
I have a value in Column A (we'll call it value A) and with a single formula I'd like to try and be able to compare it to 6 other values in cells adjacent to it (Columns B, C, D, E, F, G) and in Column H we have a formula tell us if A is:
Below B = 0
Between B and C = 1
Between C and D = 2
Between D and E = 3
Between E and F = 4
Between F and G = 5
Above G = 6
For example if A = 21 and the comparison values are ------->>> 3 | 17 | 24 | 29 | 38 | 51
The formula in H will return a "2"
*All values from B to G are sequential counting upwards, nothing is out of order.
I've tried this with two values (some form of an if(and) ) but now I'm at a loss with up to six. Is there a way to do this even?