We have started the formula in the snapshot above. To add a comment based on the rating, we are going to use the IF function. In this column, we want to add comments about the scores. This way, when a manager looks at the worksheet, he/she doesn't need to worry themselves with the actual rating – and what that means. Now, we want to add another column called Comments. In the worksheet below, we have a list of employees, followed by the rating they received as part of their annual review. If it's false, we put what happens when it's false. If it's true, we put what happens when the answer is true. Next, we add the evaluation criteria. For example, is six greater than three? The evaluation criteria asks a question. The question has two outcomes. If the answer (or outcome) is correct, such as 'Yes, six is greater than three,' then the answer is true. If not it is false. Then, we begin the formula that Excel will use to produce the results we want. The syntax for the IF function is =IF. This lets Excel know that it is an IF function. Now the formula will determine the PPV group for each article.The IF function helps to determine what will be displayed to those who view your worksheets in Excel. Because of its purpose, it's one of the most important functions you will learn. IF functions can be used to add comments to your data. They can also be used to hide errors in calculations.ĭisplaying formulas from one cell in another Grab the fill handle and drag it over the rest of the cells ( C2 to C6).The formula will determine the PPV group of that article. It's time to use this formula in the datasheet. If the article doesn't fit in any of the previous groups, then it must have over 10,000 views, which puts it in the 0.02 PPV group. If it does, then the PPV group will be 0.001 and if it doesn't, the formula will move on to test if it falls in the other groups. This formula will test the views and see if the article falls in the first group. You're going to need a nested IF statement. Writing a formula to check and determine the PPV group is very much like the previous example with the car classes. Related: Useful Spreadsheet Templates to Organize Your Life So, in order to calculate the PPV revenue, first you have to see what PPV group the article falls in and then finally, multiply the PPV group with the number of views to get the PPV revenue. The writers get paid for every view, however, the pay per view (PPV) amount itself is determined by the number of views. In this second example, we have a list of articles with the views each of them has received. Observe as the Excel formula determines the class of each car.Grab the fill handle and drag it over the rest of the cells ( C2 to C8).The formula will now determine the class of the first car. This repeats seven times, until in the final statement, the value if false becomes No Class. In this instance, the value_if_false is another IF statement. The formula will eventually test the acceleration value for every class, and if the car didn't fit any of these (meaning an acceleration of over 14s) then the formula will output “No Class”. These tests will go on and on and with each IF statement, the previous IF statement will become eliminated. This test, coupled with the first test, actually tests to see if the acceleration value is between 3 and 5, which would indicate if the car is A-class or not. However, if it wasn't less than 3, then the formula will test if it's less than 5. If it is, then the car is definitely an S-class car.

In essence, the formula will test if the acceleration is less than 3 seconds.

The goal here is to write a formula that outputs the car class by reading its acceleration.

Excel if then formula text