As I have made some modifications to the formula in this thread
http://www.mrexcel.com/forum/showthread.php?t=572061
I will make it easier for new helpers to help me, as they do not have to read the whole thread
The data is
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 need is similar to this, but I will hear, if it is possible to limit the IF-statements and how
=IF(NOT(AND(F2>=A1;F2<=B1));IF(NOT(AND(F2>=A2;F2<=B2));"Error";2);1)
I need 1 and 2, so I can both get C and D
http://www.mrexcel.com/forum/showthread.php?t=572061
I will make it easier for new helpers to help me, as they do not have to read the whole thread
The data is
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 need is similar to this, but I will hear, if it is possible to limit the IF-statements and how
=IF(NOT(AND(F2>=A1;F2<=B1));IF(NOT(AND(F2>=A2;F2<=B2));"Error";2);1)
I need 1 and 2, so I can both get C and D
