Populating text based on number entered eg. PASS/FAIL
Where text is based on the number entered being below a value, where A1 is a number cell.
eg. if the number entered is less than 50, display "FAIL" (otherwise display "PASS")
=IF(A1<50,"FAIL","PASS")
Where text is based on the number entered being above a value, where A1 is a number cell.
eg. if the number entered is above 200, display the text "PASS" (otherwise display "FAIL")
=IF(A1>20,"PASS","FAIL")
Where text is based on the number being between two values , where A1 is a number cell.
eg. if the number is less than -0.05 or greater than 0.05 then display "FAIL" (otherwise display "PASS")
=IF((or(A1<(-0.05),A1>0.05),"FAIL","PASS")