IF is one of the most widely used logical functions in Excel. It tests a condition and evaluates to either TRUE or FALSE. An IF formula has two possible outputs, one when the condition is TRUE and ...