Forum Discussion
IF, IFS or maybe some other formula?
This is probably pretty easy, but I can't make it work, been trying different formulas without success, and now I need help! In one column I have values raging from -3,00 to 3,00. In the other co...
MATWS Perhaps the attached file will get you started. Use a lookup table where you set the lower boundary for each rating. In the example I've used LOOKUP, but you might as well try VLOOKUP or XLOOKUP (if your Excel version supports the latter).
Thank you! That would probably work out very well, I'm gonna try it out!