Help me to create a formula in excel.

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

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.

qa-featured

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.

Some Functions in Excel

In the status column please type the following formula.

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

Type formula in Proper Column

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.

use proper formula

In cell J4 type the following formula.

=COUNTIF(E3:E19,"PASS")

Use COUNTIF Function

In cell J5 type this formula.

=COUNTIF(E3:E19,"FAIL")

COUNTIF FUNCTION

Then you will be able to get your expectation.

Login/Register to Answer

Related Questions