For example : If the value = 70 or above the result is PASS
If the value below 70 the result is FAIL
To make the word PASS or FAIL without typing them, use the simple IF function bellow
In the example below, column A is used for value, and column B to indicate the PASS or FAIL from the value,
To make automatic PASS or FAIL without typing them, In the column B use this formula :
Read more »