IF function
The IF function is a logical function used in spreadsheet applications like Microsoft Excel and Google Sheets. It allows users to perform a test and return one value if the test is true and another value if it is false. This function is useful for making decisions based on specific conditions, such as determining if a score meets a certain threshold.
The syntax of the IF function is simple: `IF(condition, value_if_true, value_if_false)`. For example, if you want to check if a student's score is passing, you could use `IF(score >= 60, "Pass", "Fail")`. This will return "Pass" if the score is 60 or higher, and "Fail" otherwise.