N/APosted 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?
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.
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.
In cell J5 type this formula.
Then you will be able to get your expectation.