Help me to create a formula in excel.

Asked By Justin Fraank 0 points N/A Posted on - 08/21/2012

I have a table in Microsoft excel including the student's name and their marks for the subjects mathematics, English and Accounts. I want a formula in a front column which meets the following criteria.

If marks of each subject are more than 50, column should be displayed as “passed” if not “failed”.

And in another place I want the number of passed and failed student separately.

Can someone tell me a formula?

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

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #145436

Help me to create a formula in excel.

I am able to give you a formula using some functions available in Microsoft excel. I will use “and” as well as “if” functions in this case. I will take the following example in order to explain you the way.

Please see the image below.

In the status column please type the following formula.

=IF(AND(B3>50,C3>50,D3>50),"PASS","FAIL")

Now copy that formula to below the cells. Then you will be able to get the status of each student.

Type the no of passed and failed students in a separate place as follows.

In cell J4 type the following formula.

=COUNTIF(E3:E19,"PASS")

In cell J5 type this formula.

=COUNTIF(E3:E19,"FAIL")

Then you will be able to get your expectation.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel