{"id":31759,"date":"2023-11-06T22:34:58","date_gmt":"2023-11-06T21:34:58","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=31759"},"modified":"2024-03-22T18:06:44","modified_gmt":"2024-03-22T17:06:44","slug":"power-query-if-statement","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/power-query-if-statement\/","title":{"rendered":"How to Write Power Query IF Statement in Excel – 2 Easy Examples"},"content":{"rendered":"

\"How<\/a><\/p>\n

Power Query<\/strong><\/a> is a new add-in introduced in Excel 2013 by Microsoft that accesses, cleans, and transforms all that messy data and displays it in a way that Excel loves and can work with<\/strong>. A particularly powerful feature is the Power Query<\/a> IF statement, which enables users\u00a0to test conditions and take action accordingly<\/strong>.<\/p>\n

In this article, you will be covering the two methods<\/strong> for incorporating Power Query IF statement in Excel –<\/p>\n

Download the Excel Workbook below to follow along and understand How to Write Power Query IF Statement in Excel \u2013<\/h4>\n

download excel workbook<\/strong><\/span>Power-Query-IF-Statement.xlsx<\/span><\/a><\/h4>\n

Let’s dive into the practical applications of the Power Query IF statement.<\/p>\n

 <\/p>\n

Method 1 – Using Conditional Column<\/span><\/strong><\/h3>\n

In Power Query, you can add a conditional column to apply a condition and determine the corresponding value. Let’s consider an example where we categorize products as “Fast Selling” or “Slow Selling” based on the quantity sold.<\/p>\n

Suppose you have a list of products with the quantity sold listed<\/strong> in a data table. If the quantity sold is greater than 50<\/strong>, the product category will be fast selling<\/strong> else slow selling. Follow the steps below to add a conditional column in Power Query –<\/p>\n

STEP 1:<\/span><\/strong> Highlight the data table and go to Data<\/strong> and select From Table\/Range<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

STEP 2:<\/span><\/strong> In the Create Table dialog box, select OK<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

STEP 3:<\/span><\/strong> In the Power Query window, go to Add Column<\/strong> > Conditional Column<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

STEP 4:<\/span><\/strong> In the Add Conditional Column dialog box, name the new column “Product Category.”<\/p>\n

\"How<\/a><\/p>\n

STEP 5:<\/span><\/strong> Set the column name to “Quantity Sold”<\/p>\n

\"How<\/a><\/p>\n

STEP 6:<\/span><\/strong> Choose the operator as “is greater than”.<\/p>\n

\"How<\/a><\/p>\n

STEP 7:<\/span><\/strong> Enter the value as 50<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

STEP 8:<\/span><\/strong> Specify the output as “Fast Selling”.<\/p>\n

\"How<\/a><\/p>\n

STEP 9:<\/span><\/strong> Enter “Slow Selling” as the Else value.<\/p>\n

\"How<\/a><\/p>\n

STEP 10: <\/span><\/strong>Finally, go to Home<\/strong> and select Close & Load<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

This loads the data, now with the new conditional column, back into the Excel workbook.<\/p>\n

\"How<\/a><\/p>\n

 <\/p>\n

Method 2 – Using Custom Column<\/span><\/strong><\/h3>\n

Alternatively, you can write the IF statement in Power Query similarly to how you write an IF<\/strong><\/a> function in Excel. The syntax<\/strong> is as follows:<\/p>\n

if condition then value1 else value2<\/strong><\/p>\n

where,<\/p>\n