Excel Help

[savya]

I need a formula that will take a value in a cell and return both a letter and a percent grade into two adjoining cells... I can figure it out, but... I don't wanna.



Ok, so I have point values in one cell, ranging to the nearest tenth, from 0 to 4. The corresponding values are below. I know it takes an IF/THEN/ELSE statement, but I don't have the time or energy to figure out how to do it. The left hand column are the POSSIBLE values, the middle column is the letter grade, the right-hand column is the equivalent percent (no, it's not mathematical... I only use percents because I *HAVE* to give an equivalent)

So, I think I need two cells worth of formula... one to generate the letter grade, and one to generate the percent. Help??

4 A 95
3.9 A- 93
3.8 A- 92
3.7 A- 90
3.6 B+ 89
3.5 B+ 88
3.4 B+ 88
3.3 B+ 87
3.2 B 86
3.1 B 85
3 B 85
2.9 B- 83
2.8 B- 82
2.7 B- 80
2.6 C+ 79
2.5 C+ 78
2.4 C+ 78
2.3 C+ 77
2.2 C 76
2.1 C 75
2 C 75
1.9 C- 73
1.8 C- 72
1.7 C- 70
1.6 D+ 69
1.5 D+ 68
1.4 D+ 68
1.3 D+ 67
1.2 D 66
1.1 D 65
1 D 65
0.9 D- 63
0.8 D- 62
0.7 D- 60
0.6 F 59
0.5 F 58
0.4 F 50
0.3 F 45
0.2 F 30
0.1 F 10
0 F 0