How+to+Use+If+Functions

When using the if function, the idea is to make it so that the end result that appears within the selected cell is based off of a true or false statement. For example, lets say you want all numbers that are positive to be listed as "good" and all negative numbers as "bad", this would be an instance in which you would use an if function. First things first, you would have to type in "=if(" into the cell you desire this information to appear in. After you have done this you have to enter in the "true-false" concept/question. For the given example you would type in the data your trying to prove is positive or negative and either >0 or <0. Once you have the question/concept typed in you would press the comma button and first enter the result if the answer to the question is true. Depending on which concept you used (>0 or <0) the true and false results will be different. Good results to use would simply be putting "good" and "bad" and make sure that you use the quotes or else this will not work.

Lastly, close your parenthesis and there you have it. Your if function is now complete. "If" functions are very useful functions, as they allow one to have their data automatically change, depending on the function entered, which saves them the hassle of having to make these changes themselves