## Day 13 - If Function

One of the most useful functions in Excel is the IF function. It tests a value in a specific cell to see if that value meets a certain condition. If the value does meet the condition, one result will happen, if false, a different action will occur.

Click here for a quick demonistration of the IF function. After going over the demonistration, click here to open the Excel format of the file and complete using IF function.

**Logical_test**is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.**Value_if_true**is the value that is returned if logical_test is TRUE.**Value_if_false**is the value that is returned if logical_test is FALSE.Click here for a quick demonistration of the IF function. After going over the demonistration, click here to open the Excel format of the file and complete using IF function.

## Case|Payroll

## Instruction## Instruction file is not required for this particular assignment. Go to the Data Files tab and under Day 13, open the "Payroll" workbook. |
## Data File RequiredThis particular assignment requires a data file to start. There is no instruction file for this assignment. Go to the Data Files tab and open "
Payroll" workbook to start.If you're working in the classroom, you may find the Data File in the Share drive. |