Transcription
Here’s how you can use the IF function in Excel. So in this example, we have an order form that has an item – t-shirt, and a quantity. Let’s make it so when there’s more than 5 t-shirts, the shipping cost is free.
So, instead of 14.95, let’s just press =, that will start writing a formula, and then we’ll type IF, and then open parentheses. If cell C4 is greater than 5 – right here it says value if true – so if that’s true that it’s greater than 5, what would it say? Free, right?
And then if it’s false – you notice I press a comma and then you see false is highlighted there in bold? That means you’re now specifying what happens if it happens to be false. So in this case I’ll just put 14.95. And then we close the parentheses, press ENTER.
Now let’s test it. I’m going to put a quantity of 4 – you’ll notice it remains 14.95. If I put a quantity of 20, it becomes free. If I put 5, it goes to 14.95 – because we specifically asked for greater than 5… so 5 doesn’t count.