# if and nested if in excel 2011 for mac

**“If”** is a function in excel that can help us to do logical selection with the data. **If **function not only can be used for single logical selection, but also can be used multiple times using nested if method so we can do a complex logical selection.

In **If** function, the parameter that we must be aware are:

- logical test: in logical test, we test the data for logical evaluation (e.g: E5 > 10.000)
- value if true: value that given if the logical evaluation result true
- value if false: value that given if the logical evaluation result false

below is the example:

we want to evaluate the value of house of bean, the logical test is to evaluate the sales value (E15>500000), if the result is true, the answer will be “good”, if the result is false, the answer will be “bad”. By the function below, the result will be “good”.