Bayt.com

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.

Microsoft Excel
user-image
Question added by Shameer kp , General Accountant , RUBANA GENERAL TRADING LLC
Date Posted: 2015/05/05
Upvote (0) Views (4) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
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

Write Your Answer
More Questions Like This