IF logic testvalue if truevalue if false The IF part of the function is the logic test. IF VLOOKUP E2A2B11200Item Not AvailableItem Available. IF C2 Yes then return a 1 otherwise return a 2 IF C21YesNo In this example the formula in cell D2 says.
IF OR condition1 condition2 value_if_true value_if_false.
Use dollar signs to keep one cells formula the same regardless of where it moves. Download the Excel file and choose one of the IF formulas explained on this page. IF C2 1 then return Yes otherwise return No As you see the IF function can be used to evaluate both text and values. To check that we will use the vlookup along with the IF function a vlookup function will look up the number of item values and the IF function will check whether the item number is greater than zero or not.