Hi all,
I need advice on how to go about getting excel to automatically work out which range something sits in. Let me explain further, I have 4 ranges of numbers these relate to an hourly pay rate. range 1 (7.5-7.75) range 2 (7.76-9.13) Range 3 (9.14-9.75) range 4 (9.76-10). at present I have a cell for putting in the current pay rate and a cell for range that I currently fill from a drop down list. I want excel to generate what range the pay sits in as I type the pay amount in. How do I go about it?
Bookmarks