ExcelBanter - How do use the if formula

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How do use the if formula (https://www.excelbanter.com/charts-charting-excel/135284-how-do-use-if-formula.html)

Fahim

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?

John

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?

All times are GMT +1. The time now is 04:50 PM.