need help
I would like to know which formula should i use in this case:
I have one worksheet with these values:
1st worksheet
Column A B
1,045.00 ぎ 1.20
1,050.00 ぎ 1.60
1,055.00 ぎ 2.00
1,060.00 ぎ 2.40
1,065.00 ぎ 2.80
1,070.00 ぎ 3.20
1,075.00 ぎ 3.60
1,080.00 ぎ 4.10
1,085.00 ぎ 4.50
1,090.00 ぎ 4.90
1,095.00 ぎ 5.30
1,100.00 ぎ 5.70
(each value on column A corresponds to the one in column B)
2nd worksheet
Then, i have a result .
If i have a result between 1045 and <1050, how can i attribute in another
cell 1.20.
Thank you
Jimmy
|