Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

There are 50 student in a school and five subjects. each subject pass mark is 35/100 and total mark should be more than 250. what will be the formula.

user-image
Question added by Shameer kp , General Accountant , RUBANA GENERAL TRADING LLC
Date Posted: 2015/05/05
Deleted user
by Deleted user

use the below formula

 

=IF(AND(C3>=35,D3>=35,E3>=35,F3>=35,G3>=35),IF(H3>=250,"P","F"),"F")

1   A B C D E F G H 2   Student sub1 sub2 sub3 sub4 sub5 Grand Total Result 3   X 35 36 90 56 35 252 P

 

Mahaveer Rathi
by Mahaveer Rathi , Lecturer (Computer Science)/Head of Department of Computer Science , SZABIST Intermediate College

Click the below link to get the answer of your entered problem.

 

 

Solution of your problem

 

Sol

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.