From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Nest IF and AND

Nest IF and AND - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial Buy for my team

Nest IF and AND

“

Let's get a little more sophisticated with our Power Query formulas. Here, we have applicants, and we're trying to figure out who gets an interview and moves on to the next phase. We've got portfolio scores and application scores to get an interview. There's two criteria; One, the sum of the scores have to be 13 or greater, and each of the scores have to be five or greater. Therefore look at applicant 4. The nine and four do add up to 13, but the application score is four. It is less than the five threshold. All right. Let's get at it. Cursor in the dataset, right-click, GetData from Table/Range. Now, here's our data, and I could take a bunch of steps going through adding the columns together and then do a conditional column. That would be a lot. We're going to do an IF and. So I'm going to add column, custom column. I'm going to call this interview. With IF statements in Power Query, we have to think if then else. We start with if. If what? If the portfolio score plus the application…

Contents