I need help ! I see that I can only do 7 "if then else statements" in
excel. I need to do about 20. I do not know VBA. Is there any
workaround in excel ? Here is a simple example of what I am trying to
do –

To be able to have each line in a spreadsheet do a search for a value
that can fall between anyone of 20 different areas (where each area has
a preset value) and show that value in a separate cell
Similar to a teachers grade book with 20 options instead of the regular
A,B,C,D etc.

96 – 100 value of 1
91 – 95 value of 2
86 – 90 value of 3
81 – 85 value of 4
76 – 80 value of 5
71 – 75 value of 6
66 – 70 value of 7
61 – 66 value of 8
56 – 60 value of 9
and so on

Any help would be greatly appreciated


--
tzip123
------------------------------------------------------------------------
tzip123's Profile: http://www.excelforum.com/member.php...o&userid=31878
View this thread: http://www.excelforum.com/showthread...hreadid=516076