# Calculate the Excel Formula for Pass or Fail

Edited by Djinu, Alexander Avdeev, Eng, Sangay Phuntsho and 4 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 I need formula for calculating result as pass and fail and also grade?
- 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 get the count of pass and fail for country list?
- 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 How to automatically mark passed or failed just by typing the students rating in Microsoft excel?
- 3.9 How do I write : If a column contains the value "Fail", then the formula will return Fail. Else, Pass?

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

### I need formula for calculating result as pass and fail and also grade?

*In a single formula I need result and grade also*

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

### 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 get the count of pass and fail for country list?

* Hi,. . I have a few set of Countries name and as well as pass and fail against them now I need a formula to count how many number of case passed & failed for that particular country . . for example London, I have 3 fail and 3 pass same way for other countires. I have tried: I tried count if and countifs formula but I get failed and pass count all together not for that specific country. I think it was caused by: Trying to figure it out *

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.

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

### How to automatically mark passed or failed just by typing the students rating in Microsoft excel?

* Using Microsoft excel, how to setup on marking passed or failed *

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

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

- 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: Bless, kabeer, Anonymous