Forum Discussion
Auto select a band
HI I am hoping someone can help me. I have series of bands; 1. <5.9 2. 6-8.9 3. 9-11.9 4. 12-14.9 etc etc I'd like to be able to insert a number (e.g 7) into a cell and for the adjacent c...
Hi Nick,
This should work for you, see image
=IF(C8<C2,A2,IF(AND(C8>B3,C8<B4),A3,IF(AND(C8>B4,C8<B5),A4,IF(AND(C8>B5,C8<B6),A5,""))))
Rich
