Hi to all
What I want to do is avoid using nested ifs because it would take A LOT of work, and I think it would be pointless
I have a spreadsheet with a table in H10:I14 which has:
1 3 5 8 9 12 15 20 21 45
And so on, for like 400 rows.
Above that table in cell A2, B2 etc I want to put a formula which compares a number in A3, B3, etc up to AUF3 with those ranges and return 1 if it's within one of those ranges and nothing if it isn't.
For example if in A3 I have the number 2, I should see "1" in A2 (because it's between the first range 1:3), but if there's a 4 in C3, there shouldn't be values in C2.
I know I could use nested IFs (=IF(AND(A3>H10;A3<=I10);1;IF(AND(A3>H11;A3<=I11);1; and so on but I have A LOT of ranges and i think this could be solved easily, but I don't have the resources and experience to come up with a simpler solution
What I want to do is compare all ranges at the same time with one cell, which is that A2, B2, C2, etc
Thanks in advance
Bookmarks