Do you mean this or something different?
=LOOKUP(A1,{0,100,175},{"Low","Medium","High"})
Given a score in A1 if it's 0-100 its low, 100-175 medium, over 175 is High.
Do you mean this or something different?
=LOOKUP(A1,{0,100,175},{"Low","Medium","High"})
Given a score in A1 if it's 0-100 its low, 100-175 medium, over 175 is High.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks