Matt Refghi

How to Use IF Functions In Excel

by

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? … Read more