Browsing all articles tagged with Statements

How to Embed 8 If Statements into 1 Zaheer Guides ,

MS Excel If function is very useful in the decision making process while you are considering your spreadsheets. It helps in generating and in testing if the data or the state of your spreadsheet is true or false. The function will carry out an action if the condition or state of your spreadsheet is true or false. If the condition is true then the function will carry out the specific task you have embedded on the function. These actions can be the execution of specific formulas, insertion of certain text or statements, or to leave the cell blank.

In order for the IF function to it needs to have a comparison for it to function. The most common comparison of IF function is the greater or leer than values. These symbols >/< is commonly used to create expressions which means a number is greater than a number, or vice versa. This expression can be true or false which will depend greatly on the IF function for the action to be done. There are three basic parts of an IF function in Excel. These parts are the comparison function, what action will be taken if the function is true, and what action will be taken if the function is false. Also, there is a built-in wizard that could help you in making your own IF function Excel. To go to the function select on Insert menu and choose Function. After, click on the Logical function from the drop-down selection. Now, click-on the IF function and hit OK.

On the Function Arguments dialogue box, input on the Logical test box, Value if true, and Value if false your arguments or the functions for you formula. Right after inputting the IF functions, click OK. Logical test answers what you are asking. Example of a logical test question could be “Is the value in Column C greater than the value in Column D?” In the Value if true asks the question what you want to display if the answer to the question is true. In the Value of false it answers the question what you want to display if the answer is false.

To create IF statements the arguments must be separated by commas, an example would be =IF (A1>B2,”yes”,”no”) formula and place it on the C3 cell. This means that IF the value of A1 is greater than that of the value of B2 the C3 cell will show a yes answer and if the result is opposite the answer on the cell would be no. Remember that if you want the text to be displayed on the cell you must include the text with the quotation marks on the formula itself. On the other hand, if you will be using numbers then you do not have to enclose it with quotation marks.

You can also use the IF statements in assessing your workers performances, such as in deciding whether to fire them or give them a raise. You can enclose on the quotation marks, such as the one above with the words fired or rise. There are definitely numerous ways to make use of IF statements.

You can also repeat the IF statements or formula on the rest of the rows or columns. In case the IF statement is on the C2 cell then all you have to do is to point on the C2 cell on its corner. Wait until a black cross appears and then drag it down or right to left, depending on the cells you want to contain the same arguments or statements. Also, you can do the simpler way such as point on the corner of the cell and double click to have the same statements on the succeeding columns. Likewise, if you are to update the first or source cell of the statement you can do that and do the same process to have an update on all the cells.

The IF function or statements can be useful in Excel 2007, Excel 2003, and even for Excel 2000 version. Also, the maximum IF function of seven can be nested on the arguments for it to elaborately create and construct tests. If you are planning or aiming to do more than seven statements you can consider using LOOKHUP, VLOOKUP, and HLOOKUP functions.