Return Result If Number Is Within Range
I run into this problem a lot, and each time I have to kludge together a
solution that seems overly complicated. Maybe someone knows of a more elegant
way?
Say I've got the following table:
Score Range | % Adjustment
601+ | 5%
501-600 | 4.5%
426-500 | 4%
376-425 | 3%
etc.
Say I have a score of 580...this needs to correspond to a 4.5%. I know I can
get that answer by doing some nested SUMPRODUCT functions...but is there an
easier way?
TIA.
--
Hmm...they have the Internet on COMPUTERS now!
|