Deliver Mark Formula with airSlate SignNow

Generate equation voucher

Today's video is about Excel's IF function. How can we use it alone? How do we know if we need more than one IF? How can we combine it with other logical functions such as AND or OR functions? Whenever you need a formula that's based on a condition, such as you need to mark or flag entities separately if their value's above 200 in revenue, an IF can do a good job here. The way you know if you need a nested if, that means you need to use another IF inside an IF, is when you use buts in your sentences. Let's say we need to mark entities if their value is above 200, but if their value is below 50, we need to follow up on them. Let's take a look at some examples. In this example, I have a list of apps, and I have the revenue that's associated with each app. I've been asked to solve for these. For the first case, I need to mark apps with the word Good if the revenue is above 15,000. We're going to start off with IF. The first argument is our logical test. What is our logical test in this case? Is this value, right? That's our revenue, and if this is greater than 15,000 ... I can either type it in like this or if I have these values in other cells, I can reference those cells. Obviously you're going to be more flexible if you go with a cell referencing route, because it could be that I change the threshold next month to 20,000. It's much more transparent and easier for me to manage if I just have to go to one cell and change that number, instead of finding the formula, changing it in that formula, and then dragging it down and making sure that it applies to everything else. I'm not going to type it in here. I'm actually going to reference this cell, but when you do the cell referencing route, you have to keep the fixing in mind, Right? That I can do in one go with the F4 key. That's basically my logical test. Check is this value greater than this value. If it is, then we go to our next argument. What should it do? Here I want to type in Good. Again, I can type it in like this, but you have to be careful, because if you're typing text in a formula, you have to put it in quotation marks. In this case, I also want to do a cell reference. So I'm going to reference this cell, and again I'm going to fix it. Okay, so that's what it should do if this does happen, and if it doesn't happen, then I want it to do nothing. Nothing, in Excel, means you can put in a double quotation mark. Close the bracket. Press Enter. Now we're going to send this formula down and just double check....