# How to use function in this perticular statement

#### vishwajeet_chakravorty

##### Board Regular
Kindly help me
If a student get 90 or more than 90 He will get Grade "A+"
If he gets 80 to 89 "A"
If he gets 70 to 79 "B"
If he gets 60 to 69 "C"
If he get less than 60 "D"
Now how to use if function in this statement.
If there is any other function which can be applied for this statement, kindly let me know.

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Kindly help me
If a student get 90 or more than 90 He will get Grade "A+"
If he gets 80 to 89 "A"
If he gets 70 to 79 "B"
If he gets 60 to 69 "C"
If he get less than 60 "D"
Now how to use if function in this statement.
If there is any other function which can be applied for this statement, kindly let me know.
Assuming the grade is in cell A1:
Code:
``=IF(A1>=90,"A+",IF(AND(A1>=80,A1<=89),"A",IF(AND(A1>=70,A1<=79),"B",IF(AND(A1>=60,A1<=69),"C","D"))))``

Replies
2
Views
87
Replies
2
Views
41
Replies
1
Views
193
Replies
4
Views
203
Replies
7
Views
283

1,203,174
Messages
6,053,912
Members
444,694
Latest member
JacquiDaly

### 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