a difficult excel formulae??
there is a total of 7 subjects and the formula is pass or fail
The Conditions for a PASS is as follows :
2 Credits (50% or above) and 3 passes (40% or above) including English
plz help me , i dnt knw knw wat to do
Favorite Answer
=IF(AND(COUNTIF(D15:H15,”>=50″)>=2,COUNTIF(D15:H15,”>=40″)>=5,H15>=40),”pass”,”Fail”)
Assumed. You have 7 columns with marks or percentages.
D15:H15 = the range that contains results
H15 = English Subject
Change the references as you need them. But the rest of the formula should be fine. If you use percentages, change those values also.i.e.40 & 50 to 40% & 50%
(same formula – i broke it down since i could not see it in full in the preview
=IF(AND
(COUNTIF(D15:H15,”>=50″)>=2,
COUNTIF(D15:H15,”>=40″)>=5,H15>=40),
“pass”,”Fail”)
this is confusing
- Academic Writing
- Accounting
- Anthropology
- Article
- Blog
- Business
- Career
- Case Study
- Critical Thinking
- Culture
- Dissertation
- Education
- Education Questions
- Essay Tips
- Essay Writing
- Finance
- Free Essay Samples
- Free Essay Templates
- Free Essay Topics
- Health
- History
- Human Resources
- Law
- Literature
- Management
- Marketing
- Nursing
- other
- Politics
- Problem Solving
- Psychology
- Report
- Research Paper
- Review Writing
- Social Issues
- Speech Writing
- Term Paper
- Thesis Writing
- Writing Styles