How to Use IF Function in Google Sheets

Name: How to Use IF Function in Google Sheets
Uploaded: 2025-07-20T07:00:16-07:00
Description: Learn how to effectively use the IF function in Google Sheets to automate commission calculations based on sales amounts. This tutorial guides you through creating logical expressions to determine commission rates.

Learn how to effectively use the IF function in Google Sheets to automate commission calculations based on sales amounts. This tutorial guides you through creating logical expressions to determine commission rates.

I'm gonna show you how to use the if function in Google Sheets. Say we want to change these commissions to, based on the amount of the sale, say under a hundred dollars, we only want to give 10% and over a hundred dollars. We want to give 15% commission. And we don't want to have to hand code this, right? We want to actually just do this automatically. So let's replace this number with an equal sign. And if function , what we need in the if function is a logical expression that's going to say true or false. in our case, we're gonna say B two is less than. 100 and now we have two options. We can say what is the value, if it's true, and then we're gonna add another comma, and say, what is the value? If it's false? If it actually is under a hundred dollars, we're going to say 0.1.

And if it's over a hundred dollars or it's not under a hundred dollars, meaning this is false. We can say our other commission percentage, and so we copy paste this down and depending on which commission you want to give, you can just put it right here, 10% or 15%, and now our commission earned is just going to be equal to the sale amount times this commission. And we can always change this, right? We can say instead of 0.1 0.05, if it's under and 0.1 for 10%, if it's over, then we go and then we can see that difference. That's how you use the if function in Google Sheets. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before.

I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.