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.
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.
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
InstructionInstruction 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. |