Please help me.. thank u -about ms excel?

Question

If the value of cell is::::Displays

100-96 A+

95-91 A

90-86 A-

85-81 B+

80-76 B

75 below B-

Answer 1

you might want a standard grades lookup() formula for this.

open up a new sheet, and try this.

- in cell A1 type a number

- in cell B1 copy & paste this formula

=LOOKUP(A1,{1,76,81,86,91,96}, {"B-","B","B+","A-","A","A+"})

then when you change the number A1, the letter grade in B1 will change.

heres what its doing.

- it looks at the number in cell A1.  

- then it looks it up the numbers position (in this case 1st thru 6th) in the 1st list of numbers

- then it uses the position to find the letter in that same position, and displays the letter grade.

you can paste this into your sheet...just change the 1st A1 to whatever cell your number is in.