Using IF statement

  • Thread starter Thread starter MeAgain
  • Start date Start date
M

MeAgain

Hi
I have spread sheet as below

Name 1 2 3 4 5 Exam% Result
Allen 6 8 5 7 6 73
Burrows 3 2 4 1 3 54

To pass a student needs an average of 4 or more and at least 50% in the
exam.

I wonder if you can help to make formula using IF satement????
thanks
 
In cell H2 enter:
=IF(AND(AVERAGE(B2:F2)>=4,G2:G2>=50),"You Passed","You Didn't Make it")
and copy down..
HTH
 
Hi

Try this:

=AND(AVERAGE(D15:H15)>=4,I15>50)

This will give you a TRUE or FALSE. You could use an IF statement like this:

=IF(AND(AVERAGE(D15:H15)>=4,I15>50),"Pass", "Fail")

Andy.
 
Back
Top