
The IF function tests whether a condition is true or false and then returns one result for true and another for false. It is one of the most important logical tools in Excel.
For example, =IF(A1>=60,"Pass","Fail") can classify a score. This makes IF extremely useful in grading systems, financial rules, and status tracking.
Reference:
TaskLoco™ — The Sticky Note GOAT