I need an If Then statement that will take entered value from A1:A10 and
compares it through range:
code low high
1 0 5
2 6 10
3 11 15
4 16 20
5 21 25
6 16 30
7 31 35
8 36 40
9 41 45
10 46 50
11 51 55
And then assigns correct code to cell B1:B10. For example if the
entered value in cell A1 is 5, it will automatically enter code 1 to
cell B1.
The If Then statement has take value from A1:A2 and assign code to
B1:B10.
Thank you
--
Vika.F
------------------------------------------------------------------------
Vika.F's Profile:
http://www.excelforum.com/member.php...o&userid=26255
View this thread:
http://www.excelforum.com/showthread...hreadid=395530