# Formula for Pass / Fail / Exceed Criteria

#### csmith14

##### New Member
Given a list of 20 numbers between 65 and 100. Anything less than 70 = Fail (F); between 70 - 93 = Pass (P); and anything over 93 = exceed (E).

What is a formula that I can use to derive results.

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### Joe4

Welcome to the Board!

For a number in cell A1:
Code:
``=IF(A1>93,"E",IF(A1>=70,"P","F"))``

#### csmith14

##### New Member
Thanks Joe4. This is my first time to use the forum. Exceeded my expectations. Thanks
csmith14

#### Joe4

You are welcome!

Feel free to come back anytime you have Excel questions!

Replies
2
Views
118
Replies
6
Views
410
Replies
0
Views
335
Replies
1
Views
52
Replies
4
Views
245

1,186,692
Messages
5,959,208
Members
438,404
Latest member
RailEngineer76

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