# Calculate the Excel Formula for Pass or Fail

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

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 pass in exam? any formula to find easily?
- 3.4 How can I get the passed or failed remarks on the spreadsheet ? what are the formula for it? I don't know what to do?
- 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?

- 4 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.

See more questions like this: I need formula for calculating result as pass and fail and also grade?

### How to find number of students pass in exam? any formula to find easily?

* I need the excel formula to find the number of students pass and fail in the subject *

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

### How can I get the passed or failed remarks on the spreadsheet ? what are the formula for it? I don't know what to do?

* I can't get it . I always study but I never get in it. how can I solve this? *

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.

See more questions like this: How to get the count of pass and fail for country list?

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

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

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

## Comments

## Article Info

Categories : Microsoft Suites

Recent edits by: abunz, Ananthan, Bless