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.

Use IF formulas

Use IF formulas - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Use IF formulas

“

In Excel, IF functions can take you a long way. Now, let me show you how to do IF functions in Power Query. We've got this dataset. We've got all of these candidates all the way down to Number 21. We've got their portfolio scores and application scores. And now, we want to figure out who moves on to an interview. And in order to do that, their portfolio and application scores have to add up to 13 or more. Let's do this in Power Query. My cursor is in the dataset. Right-click, GetData from Table/Range. Now, one thought would be, why don't we add a conditional column because we want to know, do the numbers add up to 13? Yes or no? But watch this. Add column, add a conditional column. We can't do math in here. There are fixed selections that we can make, but we can't do math. That's what keeps us from using a conditional column. So let's add a custom column and use an IF statement. Interview. That's what we want to check. Equals. Now we have to think, If then else, if then else equals…

Contents