Excel's+IF+Formulas

IF formulas are very helpful in Excel if you want to be specific about filtering. IF formulas can range from simple ones like "=IF(A1=1, True, False)" to complex ones that you would take you an infinite amount of lines to complete. You can follow the following format to successfully write IF formulas in Excel:
 * =IF ( logical_test, value_if_true, value_if_false )**

With IF Functions, you can place one into another, to better filter your results. For example, lets say you start out wanting to know which values in a range of cells are less than 5. Take a look at the following image, you can see based on the model formula above, and the formula in the image, it is pretty simple.

Now, lets say you want to better filter that result. You would nest the previous formula, to look like the following

=**Not done yet.. will finish later**=