Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
so you want to check if B23 is between those various ranges and use the appropriate matching value
exactly. check to see what range b23 falls in, then assign a corresponding value to b24.
give me a minute to do that
i set up an example sheet that has the formula you need
you can download it from here.
ok hang on....
let me know if you have any problems with that file
otherwise rate when ready
That's the one.... thanks Andrew. You're da bom!! :)