Excel+IF+Function

Excel's IF Function is a logical test that tests to see if certain conditions are true or false, and when effectively used with the SUM function, it can be really helpful with spreadsheet analysis.

The model for this function is simple, =IF(logical_test, value_if_true, value_if_false)

When the above model is applied to any cell in Excel, it should look something like this:

=IF(A1=100,True,False)

The above statement, reads "if cell A1 is equal to 100, then the function is true, if not, then the function is false"

Where ever you write "IF(A1=100,True,False)" it will bring back "True or False" depending on if cell A1 is equal to 100 or not.

The IF Function presented above would most likely be used in column B, because it would give you the results for column.