Excel Spreadsheet Formulas If Then

Post by Jenny | February 28, 2019 | Excel Spreadsheet, Spreadsheets | 3187 Views | No Comments

Excel Spreadsheet Formulas If Then – Starting to work with the SI instruction in Microsoft Excel can make the program easier and more enjoyable. If you answer the question, “Is this true or is it false?” This means that the SI tells Excel to perform an action only if something is true, and to take another action (or do nothing) if something is false. “Then” is not an Excel command but it is implicit and means “then, do this” in the program. For example, you can create an elementary statement “YES / then” to represent: “If at the end of the year the sales exceed $ 700K, then add a 15% increase to each one”. In Excel you can create YES to answer any logical question no matter how complicated it may seem.

 

Excel Spreadsheet Formulas If Then

Construction of a YES statement with a conditional
Step 1
Click on “File,” then “New,” “Blank Book,” and “Create” on the Excel toolbar in the left corner of the screen. This opens a new blank book where you can create SI or practice statements.

Step 2
Enter the numbers 33 and 12 in cells A1 and A2. Place 40 and 8 in cells B1 and B2.

Step 3
Write the following IF statement in cell C1:

= YES (A1> B1, “Yes”, “No”)

This statement means “If the number in A1 is greater than the number of B1, write” Yes. “If A1 is not greater than B1, write” No. “Be sure to start the statement in C1 with the equal sign and write the instruction As it is described, since 33 is less than 40 you will see “No” in cell C1, write the same statement in cell C2, since the value of 12 is greater than the value of 8, you will see “Yes” in C2 You can use any word or phrase you choose for the result Make sure you put the words or phrases you want to show as a result of your YES instruction in quotes.

Step 4
Repeat the IF statement automatically instead of rewriting it in each cell. Click on cell C1, then take the cell’s fill driver in the lower right corner with the mouse and you will see that it becomes a black cross. Using your mouse, drag the cell across the column to cell C6. Direct your attention to the contents of cell C2 and note how C2 calculated the SI formula automatically. When it was dragged to cell C6, the SI was automatically copied from C1 and applied to all cells from C2 to C6. Enter the numbers at random in the cells from A3 to A6 and from B3 to B6. You will see the results “Yes / No” of the IF statement in column C through cell C6.

Step 5
Enter the IF instruction in cell C1 writing about what is already there:

= YES (A1> B1, 100,1000)

This statement means “If the number in A1 is greater than the number of B1 write” 100 “, otherwise, write” 1000 “After writing the statement in cell C1 you will see” 100 “as a result since 12 is greater than 8. Note that you do not need quotes in your SI statement for numerical values.

Construction of an SI declaration with more than one conditional
Step 1
Enter H, M, M, H, M in the cells from A1 to A5. Do not use quotes with these letters that represent men and women.

Step 2
Enter the numbers 12, 11, 5, 14 and 17 for the cells from B1 to B5. These numbers represent ages.

Step 3
Write this IF statement in cell C1:

= YES ((Y (A1 = “H”, B1> 12)), “Give him 2 teaspoons of the medication” ;, “Give him 1 teaspoon of the medication”;)

This SI instruction has two conditions and translates to: “If the child is male and over 12 years of age, write” Give him 2 teaspoons of the medication “, otherwise write” Give him 1 teaspoon of the medication “. Note that the result of C1 says: “Give him 1 teaspoon of the medication.” Drag the box to cell C5 to see the other results.

Gallery of Excel Spreadsheet Formulas If Then

In addition to the image above, you can see a gallery of Excel Spreadsheet Formulas If Then below.

( Click Image to Enlarge )

Tag; Excel Spreadsheet Formulas If Then, excel spreadsheet formulas not working, excel spreadsheet formulas pdf, excel spreadsheet formulas for dates, excel spreadsheet formulas percentage, excel spreadsheet calendar formulas, list of excel spreadsheet formulas

Other Collections of Excel Spreadsheet Formulas If Then