Urgently need help from excel GURUS!!!!!

C

cybernet

How do I formulate the formulae for both problems below?

Problem:-CONDITIONS TO FULFIL
@ 1. To qualify for a scholarship, the parent's income must be less than
RM1000 PER MONTH
2. Must pass the BM subject (passing mark is 50)
3. Must pass at least 5 subjects including BM (passing mark also 50)

# 1. To qualify for a loan, the parent's income must be less than RM1500
PER MONTH
2. Must pass the BM subject (passing mark is 50)
3. Must pass at least 5 subjects including BM (passing mark also 50)
4. Students who have already qualified for a scholarship is NOT
entitled to the LOAN

Can some kind soul out there help me to solve this problem by giving me the
appropriate formulae
for each of the problem above.
 
B

BenjieLop

cybernet said:
How do I formulate the formulae for both problems below?

Problem:-CONDITIONS TO FULFIL
@ 1. To qualify for a scholarship, the parent's income must be less
than
RM1000 PER MONTH
2. Must pass the BM subject (passing mark is 50)
3. Must pass at least 5 subjects including BM (passing mark also 50)

# 1. To qualify for a loan, the parent's income must be less than
RM1500
PER MONTH
2. Must pass the BM subject (passing mark is 50)
3. Must pass at least 5 subjects including BM (passing mark also 50)
4. Students who have already qualified for a scholarship is NOT
entitled to the LOAN

Can some kind soul out there help me to solve this problem by giving me
the
appropriate formulae
for each of the problem above.
Click to expand...

I do not consider myself an Excel guru but I can help you. Here is the
set up that I have to solve your problem.

In Cell A3 -- student's name
Cell B3 -- parent's income
Cell C3 -- BM Grade
Cell D3 -- Grade in Subject 1
Cell E3 -- Grade in Subject 2
Cell F3 -- Grade in Subject 3
Cell G3 -- Grade in Subject 4
Cell H3 -- Grade in Subject 5

To determine if the student qualifies for a scholarship, enter this
formula

=IF(AND(B3<1000,C3>=50,COUNTIF(D3:H3,\">=50\")>3),\"OK\",\"NO\")

in Cell J3.

and, to determine if the student qualifies for a loan, enter this
formula

=IF(AND(B3<1500,C3>=50,COUNTIF(D3:H3,\">=50\")>3,J3=\"NO\"),\"OK\",\"NO\")

in cell K3.

You can copy these formula down along both Columns J and K until your
range requirement is met.

Hope this will help you.
 
C

cybernet

Can you please elaborate because I am quite new in using excel but was
requested by my school administrators to solve the given problem.
 
Top