From the course: Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) Cert Prep

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Perform conditional operations using the IF() function

Perform conditional operations using the IF() function - Microsoft Excel Tutorial

From the course: Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) Cert Prep

Start my 1-month free trial Buy for my team

Perform conditional operations using the IF() function

“

- [Instructor] When working with our data in Excel we can use an if function to determine if a condition is met and then return one value if it's true and one value if it's not. Let's jump right into our if workbook and take a look at how we can use the if function. We're in the 0505 if workbook on the payroll worksheet. And we want to determine whether or not each of these employees are full time. Now in our company, full time is considered working 40 hours or more. We'll start in cell G five and type equals if and tab to step into our if logical test function. If the amount in D five is greater than or equal to 40 because that's our criteria, I'll type a comma in because the value if it's true, will be the word true. So in quotation marks, I'll type in true in quotation marks and type a comma. Now, the value, if it's fault, if it's less than 40 hours a week will be false, also in quotation marks. Let's close our…

Contents