Hello,
Excel 2016
I have an array similar to this:
20 447
21 5018
22 5624
23 6291
24 7028
25 7842
26 874
27 973
28 10824
29 12031
30 13363
The array starts from 1 to 120, so it is 120 different cells to read.
The thing i would like help to, is:
If the input cell is between 447 to 5017 the output cell with the formula shows 20.
If the input cell is between 5018 to 5623 the output cell with the formula shows 21, and so on.
Is this possible without the use of 120 different IF functions in the same formula?
//Boehnke
Bookmarks