Question: what is the formula for finding pass or fail in excel?
Answer: A. Enter this formula in cell C4: =IF(B4<70,”FAIL”,”PASS”) . This means if the score in B4 is less than 70, then enter the word FAIL in cell B4, else/otherwise enter the wordPASS. Copy this formula from C4 to C5 through C13.