Excel® 2013 On Demand

Using Logical Functions

You can use logical functions to help you test whether conditions are true or false or make comparisons between expressions. The logical functions in Excel include: AND, FALSE, IF, IFERROR, NOT, OR, and TRUE. The structure of the IF function is IF(logical_test, value_if_false, value_if_false). For example, IF(E6<31,F6,””). If E6 is less than 31, then display the contents of F6; if not, then display nothing. You can also nest logical functions within a logical function. For example, IF(AND(E7>=61, E7<=90),F7,””). If E7 is greater than or equal to 61 and less than or equal to 61, then display the contents of F7; if not, then display nothing.

Use Logical Functions

Click the cell where you want to place the function.