I'm having some problems working out how to get excel to show me one value dependant on if another value is between two others, I've tried a nested IF formula, but I'm really struggling to get it to work.
Here's the problem.
I Have a list of figures between 0.1 and 1.0 (these figures are predominantly decimals such as 0.23, 0.61, 0.8 etc), and I want that to be converted to a number between 1 and 4 dependant on where they fall in the range.
So if the number is between 0 and 0.25 it would equal "1"
If the number is between 0.26 and 0.5 it would equal "2"
If the number is between 0.51 and 0.75 it would equal "3"
If the number is between 0.76 and 1.0 it would equal "4"
I'm hoping there is a way to do this! Thanks very much in advance for all your help!
Also I hope the thread title is okay! I don't really know how to phrase it!
CCA BSM