Logic+Statements+(If+Clause)+in+Formulas

Often times it may become necessary to make use of logic statements in an excel formula. A logic statement is often refered to as an If clause. Basically what it does is, it makes the references cell pass through a level of criteria, if it qualofies for one chriteria, then use ... (insert) formula, if it does not, but qualifies for a different formula, (insert) formala to be used. --     In the example below i took a look at customers with balances over $1000.00 in Column D i wanted to insert a formula that would tell me the dilinquency status, based off the balance each customer has in Column C     As you can see, the formula that was used is as follows: **//=IF(C2<1000,"Standard Delinquency", IF(C2>1000,"Very Delinquent"))//** __(note) I am not actualy making any calculations here, i am simply telling excel that:__ If the balance is < 1000 the term "Standard Delinquency" should be written in the appropriate cell in Column D     -accordingly- If the balance is > 1000 the term "Very Delinquent" should be written in the appropriate cell in Column D



The last thing that remains is copying our formula to the bottom of the page giving us the results below. (hint: check your info after you are finished to make sure it looks correct, and that it answers your original question

__Final Product:

__