Learn how to use a nested IF function. Author Jen McBee demonstrates how to create a formula using the IF function, in conjunction with VLOOKUP.
- [Narrator] As you know, the IF function allows you to…make a logical comparison between a value…and what you expect by testing for a condition…and returning a result of true or false.…In this video, we're going to create a nested IF function…that will nest a VLOOKUP function in our IF function.…Let's take a look at our 0401 nested IF document.…This sheet contains the sales for 2017,…and we see for each of our sales people…their actual sales, their goal,…and over in cells F, G, and H we see the sales goals,…the level that they can achieve,…and the commission that they will earn.…
We'll create an IF statement that will look…at the sales and the goal,…and if the sales are greater than or equal to the goal,…it will step into the VLOOKUP function.…In VLOOKUP, we'll look at the sales goal…and come over to column F and find that goal,…and return the commission rate.…We'll then take that commission rate…and multiply it times their 2017 sales in column C.…Now, if their sales is not greater than or equal to…the goal, we'll have the formula stop right there…
Author
Jennifer McBee
Released
5/4/2017In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.
- Explain how AutoRecover saves and stores files.
- Identify three elements users can change when creating a custom theme.
- Summarize the capabilities of form controls.
- Recognize situations when a nested IF function would be most appropriate.
- Recall the purpose of a Watch window.
- List the steps to enable iterative calculations.
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome57s
-
-
1. Microsoft Office Specialist (MOS) Expert Exam Overview
-
2. Manage and Share Workbooks
-
Create and modify templates4m 15s
-
Link to external data6m 51s
-
-
3. Apply Custom Formats and Layouts
-
Create form fields5m 1s
-
4. Create Advanced Formulas
-
Use a Nested IF function3m 54s
-
Use the AND/OR functions6m 21s
-
Use financial functions3m 24s
-
-
5. Create Advanced Charts and Tables
-
Create new PivotCharts3m 39s
-
Apply styles to PivotCharts4m 20s
-
-
6. Sample Exam
-
Conclusion
-
Next steps30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use a Nested IF function