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.

Calculate Pass Fail Excel Formula.mp4-canvas62 823269.jpg

Ad

Steps

  1. 1
    We'll use the last column.
    We type "pass/fail".
    Calculate Pass Fail Excel Formula.mp4-canvas11 76561.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    We'll use the "If-then" function.
    We type "=". We type "if". We'll add the left parenthesis.
    Calculate Pass Fail Excel Formula.mp4-canvas18 624814.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    We click the column.
    We click the H3 column in this video.
    Calculate Pass Fail Excel Formula.mp4-canvas25 211427.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    We add a condition.
    It is "if it is less than seventy"; so, we type "<70". We type ",".
    Calculate Pass Fail Excel Formula.mp4-canvas35 056036.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We add a true value.
    In this example, if the grade is less than 70 (if the condition is true), then the student has failed the class. We type "Fail" in double quotation marks. We type ",".
    Calculate Pass Fail Excel Formula.mp4-canvas45 23664.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We add a false value.
    In this example, if the grade is over 70, then the student has passed the class. We type "Pass" in double quotation marks. We add a closing parenthesis.
    Calculate Pass Fail Excel Formula.mp4-canvas58 423857.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We press "Enter".
    In this example, we see that Billy Bob had a grade of 58, and he has failed the class.
    Calculate Pass Fail Excel Formula.mp4-canvas66 363857.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    We left-click and drag the formula down across all of the students.
    We'll see that Suzy Q and Mike Holmes both have passed the class.
    Calculate Pass Fail Excel Formula.mp4-canvas75 160675.jpg
    Was this step helpful? Yes | No | I need help

    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!

Was this helpful? Yes | No | I need help

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

Was this helpful? Yes | No | I need help

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"))))))

Was this helpful? Yes | No | I need help

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.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,100 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Calculate the Excel Formula for Pass or Fail"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Bless, kabeer, Anonymous

Share this Article:

Thanks to all authors for creating a page that has been read 5,373 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No