Hello
Excel is not new to me but with this I feel like a beginner…
I have a scoring model in which scores must be categorized as follows (File "Excel Table"):
This is the table I would like to base my excel formula on.
As a guide, the actual bandwidths are (File "Bandwidths_table"):
The tricky bandwidth is the „NEUTRAL“ one. Any values ranging from -0.38 to just under 0.63 must be assigned to the neutral category. Examples of desired results are as follows (file Table results):
I have tried the lookup function as well as the index function but these either work for the positive OR the negative bandwidths, but never for both.
Would be very grateful for a helping hand!!
Bookmarks