How do use the if formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use an IF formula that displays PASSING if the average of the
project grades is at or above 36 points and UNSATISFACTORY if that is not the
case?
 
if each score is in cells A1 to A4 then use =IF(AVERAGE(A1:A4)>=36,"PASSING
","UNSATISFACTORY ")
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top