Type your first name in cell A1 and your last name in cell B1. IF C2 1 then return Yes otherwise return No As you see the IF function can be used to evaluate both text and values. Click Conditional Formatting on the Styles section of the Home tab on the ribbon.
The Excel IF Statement tests a given condition and returns one value for a TRUE result and another value for a FALSE result.
IFANDB250 B2. IF A2B2Over BudgetOK IF A2B2B4-A4 Argument name. In our case thats E4F8. Either type the formula in the Formula Bar or use the Function Arguments dialog box.