J
jimmy
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
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