Learn About Pass Fail Formula In Excel In Detail.

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #299220

Learn About Pass Fail Formula In Excel In Detail.

qa-featured

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

Image result for pass fail formula in excel

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

Login/Register to Answer

Related Questions