Hi, I was hoping someone might be able to help me with this formula, or tell me why I'm getting an error. I need to check if a number fits within a certain range, and if it does, do a specific calculation, then check another range, do a calculation if it fits there, and repeat until I want it to return 0 if it does not fit within any of the multiple specified ranges.
This is a simplified version of what I'm really trying to do, but I think it's easier solved and understanding what's wrong here will let me know what's wrong in the other one I'm working on.
Thanks so much for any help.
