What are formulas to prepare marksheet of students in excel?

=IF(AVERAGE(C6:G6) < 50,"fail","pass")