Learn About Pass Fail Formula In Excel In Detail.

Asked By Pike Hayt 0 points N/A Posted on - 06/12/2017

Hi all,

I want to know about the pass fail formula in excel or how to use the ‘If’ function in Excel.

If someone knows about this, please reply.

Thank you.

• Status: Open
• Question Views: 360
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: Excel | pass fail formula

Answered By Alton P Heckel 0 points N/A #299220

Learn About Pass Fail Formula In Excel In Detail.

Let us assume that you want to decide either “Pass” or “Fail” for a student according to their test score. For that, you must check the score for each student and then return “Pass” or “Fail.”

Consider this image

Now, look at the score in cell C6. Now, you want to check this score to see if is less than 70 or more than 70; then you would use the comparison:

=C6>=70

It implies that “C6 bears a value which is more than or equal to 70.”Now, provide a value that the function will return in case the test is TRUE, and value to return if the test is FALSE.

Combining it together, the formula for D6 will become:

=IF(C6>=70, “Pass”, “Fail”)

About Alton P Heckel

Questions
3

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/12/2017
• Question Category: MS Excel