How Do You Use Excel IF Function?
Microsoft Excel 2003 allows you to create conditional formulas that perform tests on the data in a spreadsheet and return a value based on the results of the test. The main functions used in these conditional formulas are IF, AND, NOT and OR. The Excel IF function allows you to specify the kind of result that you want to be returned, such as TRUE or FALSE, or OK or NOT OK, as the result of the test performed. For example, you may create a conditional formula that will test your data to see if the sum of the values in the first twenty rows of a column, such as column D, falls below a set value, such as 100. You may calculate the sum and place the result in cell D21. Then, if the value in D21 is equal to or greater than 100, the target value is met and you want the result to be OK. If the sum is less than 100 the target value is not met, and you want the result to be Not OK. Specify the logical_test, which is the precise condition your formula is testing. In this case, the condition is w
