| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do use the if formula
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do use the if formula
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) "Fahim" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
