I'm sorry, I guess I didn't word my question too well.
When I said I'd like to avoid nested IFs, I actually meant that I'd
like to avoid nested IFs as worksheet functions, i.e. I want to avoid
writing a worksheet function like:
Writing a VBA function with nested IFs or nested Select Case clauses
would be fine; however, since I have over 20 parameters, and the
thresholds change for each of those, I'd have to write over 20. It
would be ideal if I could write just one VBA function, and then use it
for all the 20+ parameters I have to work with. Something like:
The problem is that the number of thresholds is different for every
parameter. Is there a way to generalize the function?