Validating formula results in excel 2016 teen dating violence in indiana curriculum
What is really the most powerful thing about the ‘IF’ function is that it can be ‘nested’ within and combined with other functions to create an incredible amount of flexibility to meet different requirements.The ‘IF’ function is a logical function which basically means its results are based on one of two outcomes: true or false.Let’s go…First we need to convert our data into an Excel Table by pressing Ctrl TOnce the above are done we need to create our formula.
The result hinges upon either a true or false outcome of a logical test.
This ability to nest functions is true for other functions within an ‘IF’ function as well as ‘IF’ functions within other functions.
Nesting ‘IF’ functions is especially useful when another ‘IF’ logical needs to be addressed as the result of the outcome of either the ‘value_if_true’ or ‘value_if_false’ arguments.
Notice in the nested ‘IF’ above that we have added and ‘IF’ function as the ‘value_if_false’ argument for three different previous ‘IF’ functions.
What we have essentially done is ask Excel to go down our list of 4 colors and test the value of the cell reference ‘A7’ until it either finds one of those colors or not.