## Help me to create a formula in excel.

Asked By 0 points N/A Posted on -

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?

SHARE
Answered By 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.