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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Omit empty cells? 0
calculating average handling time 7
How to create a bubble chart with more than 2 variables 0
How to graph a slope? 1
Text Result Formula 5
Need help for Excel Formula 0
lookup formula not picking up correct data 2

Back
Top