Sunday, September 13, 2009

The IF Function

The IF function in excel is for testing data in certain cells in a spreadsheet. This data can be used to tell you if data is true or false. How you use the IF function is simple. First you type an = symbol then you type IF. For example, =IF(. This tells the excel sheet that you are about to do an IF function. Then in the parenthesis select a cell in the spread sheet, for example, B3. Then you tell it if it is greater than with this symbol > or less than < or equal to = then you type in a quotations if it is true or false. =if(b3>0,”love”,”not love”). If b3 is is greater than 0 it will say love in the cell, if it is not it will say not love. This function can be copied for a group of cells.
This Function can be implanted in businesses all over the world. This world can give you a logical test to say if you should sell if b3 is less than this or you should buy vice versa. Try and use this function in business situations and see what it can do for you.

No comments: