Oz du Soleil shows how to write formulas in Get & Transform in Excel 2016. This video provides an example of nesting an AND inside an IF.
- [Instructor] Let's nest an and inside an if…in Get & Transform.…Here we've got applicant data…and we're trying to get a list of who we're going to interview…and who's going to be declined.…And the criteria, there are two.…The portfolio and the application scores have to sum…to at least 13 and…each score has to be at least five.…So, look at Applicant 2.…There is a total of 13,…but because the application score is below five,…that person is going to be declined.…
Sorry.…Okay, let's jump into this and make this formula.…Data, From Table.…Now, why are we going to do a formula here?…Because we would need so many other columns in order…to get this right, so we're going to write one custom column,…rather than do this in a bunch of steps.…So, here we go.…We're going to add the custom column.…Add, Custom Column.…
Call it Decision.…Now, we're going to do an if and we have to think…in terms of if, then, else.…We're also going to use and,…so that we can insert our three criteria.…If, Portfolio Score, greater than,…equal to five…
AuthorOz du Soleil
- What is Get & Transform?
- Querying data
- Working with columns
- Using formulas
- Pivoting and unpivoting data
- Grouping data
- Appending a query
- Merging/combining data with joins
Skill Level Intermediate
1. What Is Get & Transform?
2. Working with Queries
3. Working with Columns
4. Working with Formulas
5. Pivoting and Unpivoting Data
Group data2m 31s
7. Appending a Query
8. Merging Data with Joins
9. Putting It All Together and Applying Your Learning
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.