Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 8.52 | 1 | 5 | A | |||
2 | 6 | 10 | B | ||||
3 | B | 11 | 15 | C | |||
Sheet1 |
I need a formula for cell A3 that should output:
* value from E1 - if A1 is less than D1 and greater than C1;
* value from E2 - if A1 is less than D2 and greater than C2;
* value from E3 - if A1 is less than D3 and greater than C3;
Ex:
* if A1=8.5, then A3=B
* if A1=3.1, then A3=A
--and so on.