# Nested IF Has Me Nested!!!!

#### Amandia

##### New Member
I have to do a nested IF that regards grades. If it's between 100-90 = A, 89-80 = B, etc. and I have tried every way under the sun to make it happen and each and every time it doesn't work. Can someone please help me???

Amandia [/i]

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
It would be easier to use a lookup table. Check out VLOOKUP in Excel Help.

Hi, welcome to the board!

Code:
``=LOOKUP(A1,{0,"F";60,"D";70,"C";80,"B";90,"A"})``

Amandia said:
I have to do a nested IF that regards grades. If it's between 100-90 = A, 89-80 = B, etc. and I have tried every way under the sun to make it happen and each and every time it doesn't work. Can someone please help me???

Amandia [/i]

This would work

=IF(H19>89,"A",IF(H19>79,"B",IF(H19>69,"C",IF(H19>59,"D","F"))))

Thank you so very much!!! It worked perfectly!

Amandia

Replies
1
Views
174
Replies
1
Views
199
Replies
6
Views
158
Replies
6
Views
155
Replies
4
Views
708

1,196,328
Messages
6,014,674
Members
441,835
Latest member
rthomas268

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back