# Calculate the Excel Formula for Pass or Fail

Edited by Djinu, Alexander Avdeev, Eng, Sangay Phuntsho and 7 others

**5 Parts:**

You're watching VisiHow. In the video at Compute Weighted Grades in Excel 2016, we've shown how to calculate weighted averages. Now, we are going to show how to calculate a "pass/fail" column.

- 1 Steps
- 2 Video: Calculate the Excel Formula for Pass or Fail
- 3 Questions and Answers
- 3.1 Simple formula to declare the pass or fail?
- 3.2 How to calculate percentage pass and percentage fail?
- 3.3 How to find number of students passed in exam? Any formula to find easily?
- 3.4 I want to show in the remarks if it is passed or failed.. it didn't work because the formula that I used is wrong?
- 3.5 How to check pass or fail in the subject by using countif?
- 3.6 I won't pass or fail with grade how to create excel formula?
- 3.7 I want to calculate result sheet in excel?
- 3.8 I need to calculate if the student is pass or fail in excel?
- 3.9 How do I write: If a column contains the value "Fail", then the formula will return Fail. Else, Pass?
- 3.10 I have a question about how to formulate a percentage on Excel of "passing students" when a 1 is used for passing and 0 is used for failing?
- 3.11 Calculate mark sheet of all subject passed and failed and show grade?
- 3.12 How to verify the status of multiple cells "Pass/Fail" in one single cell of the resultant sheet?
- 3.13 To count the students whose name starts with s and marks in math is >80?
- 3.14 Prepare for me a mark sheet for junior secondary showing pass and fail results?

- 4 Referencing this Article
- 5 Comments

## Steps

- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8We'll see that Suzy Q and Mike Holmes both have passed the class.We left-click and drag the formula down across all of the students.Advertisement

This was how to add an "If-then" function to determine "Pass" versus "Fail" in Microsoft Excel. If you have any questions or comments, please leave them in the space below. Thank you for watching VisiHow!

## Video: Calculate the Excel Formula for Pass or Fail

## Questions and Answers

### Simple formula to declare the pass or fail?

*Simple formula to declare the pass or fail *
*as follow*

*dzo eng Math EVS Tot Ave Remark*
*45 55 55 66 Pass*

*Just pass is 40*

*I want the simple formula to declare pass or fail in the remark column. Condition failing in one sub is to be declare fail, but just failing in EVS is pass*

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### How to calculate percentage pass and percentage fail?

*I am working on excel with 22 number of students, each with mark score on cell rows. Average class mark is 48. I want to calculate in a single cell the percentage number of students that pass the test and in a separate cell the percentage number of students that fail the test. I will appreciate your help. The article does not cover how to calculate percentage of items in relative to a known value. I have tried: The sum if function. But the criteria is not satisfied since I am working with a number not character. I think it was caused by: My main priority cell is a single cell containing the item to determine. So the sumif function cannot work*

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### How to find number of students passed in exam? Any formula to find easily?

* I need the excel formula to find the number of students passed and failed in the subject *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### I want to show in the remarks if it is passed or failed.. it didn't work because the formula that I used is wrong?

*I am using a college grade, not a high school grade.. so how what is a formula to show that it is passed or failed using 1.00 and 2.00 or 2.75 and others. The formula that I used doesn't work, and I want to show if it is passed or failed.. and I am using college grades not high school grades.. the college grades are 1.00,1.25,1.50,1.75,2.00,2.25,2.50,2.75,3.00,4.00,5.00 the 3.00 grade is the passing grade. I have tried: I tried many formulas but it doesn't work.. please help me now, it is so very important. I think it was caused by: Wrong formula and I don't know what to do. I need an answer now*

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### How to check pass or fail in the subject by using countif?

*Name Sub1 Sub2 Sub3 Sub4 Sub5 Result. A 85 54 32 47 90 . B 38 64 57 58 74 . C 61 82 31 88 82 . D 71 33 55 93 52 . E 67 40 43 66 35 . G 64 89 35 98 75*

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### I won't pass or fail with grade how to create excel formula?

* I won't pass or fail with grade how to create excel formula. . =IF(C2>35,E2>35,avg=90,"A+") its not working. I have tried: =IF(C2>=90,"A+",IF(C2>=80,"B",IF(C2>=70,"C",IF(C2>=60,"D",IF(C2>=50,"E",IF(C2>=40,"F","Not Graded")))))). I think it was caused by: =IF(C2>=90,"A+",IF(C2>=80,"B",IF(C2>=70,"C",IF(C2>=60,"D",IF(C2>=50,"E",IF(C2>=40,"F","Not Graded")))))) *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

See more questions like this: How to apply remarks or pass/fail in excel, formula of pass/fail?

### I want to calculate result sheet in excel?

* I want a formula for pass or fail result. I have tried: If (AND (sub1>=35, sub2>=35, sub3>=35, sub4>=35), "pass, "fail") *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### I need to calculate if the student is pass or fail in excel?

*I have the ca result of students so I need to calculate if a person is pass or fail the pass marks is 38 but also I need to format the pass and fail text the result to appear in color example pass appear in green color. The format of the color that I need to appear when the failed and passed statement occur*

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

See more questions like this: How to automatically mark passed or failed just by typing the students rating in Microsoft Excel?

### How do I write: If a column contains the value "Fail", then the formula will return Fail. Else, Pass?

* How do I write: If a column contains the value "Fail", then the formula will return Fail. Else, Pass *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### I have a question about how to formulate a percentage on Excel of "passing students" when a 1 is used for passing and 0 is used for failing?

* I am a teacher. I am calculating the percentage of students who have mastered a subject. For example: the student receives a "1" for passing "0" for failing. I have 20 students. I'm trying to create a formula in excel for finding the average for the number of students who have PASSED. . . Tina 1. Brian 0. Chris 0. Tucker 1. Kelly 0. . So I just hand calculate myself: 2/5 = 40% (passing). Trying to find an easy way to do this on the spreadsheet to calculate my score. Because I am not using pass or fail...I am using 1 and 0 and I need to specifically find the average of students who have passed. I have tried: I have tried looking on Google and tried to review the videos here. But, I don't find anything which specifically answers my question. We also have an IT person, whom I asked and he did not know the answer either. I think it was caused by: I just don't know where to go to find this answer. Or even what category it fall under. Most of the time I will see how to find the average using the AVERAGE Dropbox, but this does not help me as I need to know the percentage of students who have passed. *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### Calculate mark sheet of all subject passed and failed and show grade?

* Sir, in the total subject if any subject fails then result will show fail another total subject pass then show pass. Then after show result pass then show grade, otherwise result Fail, how to do it? Thank you sir. *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### How to verify the status of multiple cells "Pass/Fail" in one single cell of the resultant sheet?

* I have a Sheet 1 wherein I have copied the test results.. I have to verify if all the test cases under a particular section say "Front Page"(Column S) is Pass or Fail (Column V) and put the status in the resultant sheet in a single cell (Column C) *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### To count the students whose name starts with s and marks in math is >80?

* I didn't find this formula and try again and again but failed! *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

### Prepare for me a mark sheet for junior secondary showing pass and fail results?

* Excel mark sheet for grade 7 students and report those who failed and passed with the highest mark. Example of prepared mark sheet for grade 7 students *

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

## Referencing this Article

If you need to reference this article in your work, you can copy-paste the following depending on your required format:

__APA (American Psychological Association)__

Calculate the Excel Formula for Pass or Fail. (2017). In *VisiHow*. Retrieved May 28, 2017, from http://visihow.com/Calculate_the_Excel_Formula_for_Pass_or_Fail

** MLA (Modern Language Association)**
"Calculate the Excel Formula for Pass or Fail."

*VisiHow*, visihow.com/Calculate_the_Excel_Formula_for_Pass_or_Fail Accessed 28 May 2017.

** Chicago / Turabian**
VisiHow.com. "Calculate the Excel Formula for Pass or Fail." Accessed May 28, 2017. http://visihow.com/Calculate_the_Excel_Formula_for_Pass_or_Fail.

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

## Comments

## Article Info

Categories : Microsoft Suites

Recent edits by: heila, Brainbenn, abunz