Using IF statement

Giganews Newsgroups
Subject: Using IF statement
Posted by:  MeAgain (gulba…@nowhere.3333)
Date: Fri, 24 Oct 2003

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

Replies