T
The87Boy
I have some data that looks like this
A | B | C | D
1 | 1.9 | a | b
2 | 2.9 | b | c
.... and so on
In F I have some numbers e.g. 1.5 and 2.3, and the formula I am using
right now is similar to the following, but I have to make more IF-
statements, when I create a now row with data, so do anybody in here
know, how I can make this formula better
=IF(NOT(AND(F2>=A1;F2<=B1));IF(NOT(AND(F2>=A2;F2<=B2));"Error";2);1)
I need the data from both C and D, so I think it will be easier to
return 2 and 1, and then look the data up, but if anybody have another
solution, I will like to hear that
A | B | C | D
1 | 1.9 | a | b
2 | 2.9 | b | c
.... and so on
In F I have some numbers e.g. 1.5 and 2.3, and the formula I am using
right now is similar to the following, but I have to make more IF-
statements, when I create a now row with data, so do anybody in here
know, how I can make this formula better
=IF(NOT(AND(F2>=A1;F2<=B1));IF(NOT(AND(F2>=A2;F2<=B2));"Error";2);1)
I need the data from both C and D, so I think it will be easier to
return 2 and 1, and then look the data up, but if anybody have another
solution, I will like to hear that