IF Function


The IF Function checks a cell to see if something is true or false. If it is true, Excel automatically puts data in the cell. If it is false, Excel automatically puts different data in the cell.


How do I use the IF Function?

Equal =

IF(B6=0, "Out of Stock", "In Stock")

If B6=0 is true, apples are out of stock.
If B6=0 is false, apples are in stock.

graphic of inventory data
  1. Click on cell C6.
  2. Click graphic of Insert Function button.
  3. In the box under Function name, Click IF.
  4. Click OK.
  5. You see this box:

    graphic of Function name 'IF' box
  6. Click in the box beside Logical_test. graphic of Logical_test box
  7. Type B6=0
  8. Click in the box beside Value_if_true.
  9. Type Out of Stock. graphic of Value_if_true box