The IF function in Microsoft Excel seems to really cause many people a lot of heartache and grief, but all in all it is actually really not that difficult of a tool to use. The essential role of the IF function is to test whether a condition is either True or False and if the condition is True it will return one value and if it is False it will return an alternate value.

Let us look at an example -

Let us say you have two values. In one cell you have a value of 65 and in the other cell you have a value of 23. What the IF function allows us to do is to do a test and lets say we want to see if the value of 65 is greater than 23. When the numbers are plugged into the If statement, the result will be that 65 is greater than 23 and it will return something from the True return area.

So how do we create an if statement