Power Query Problems

Fix Blank Results and Calculated Columns in Excel Power Query Output

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 870 views

Question details

Return a blank when a source cell is empty and prevent Excel from applying an edited formula to an entire table column.

Fix Blank Results and Calculated Columns in Excel Power Query Output
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
The user is calculating values from source columns and editing formulas in a Power Query output table.
Observed behavior
A calculation needs to remain blank when its source cell is empty, and Excel automatically fills a table column when a formula is edited.
Before you start

Check whether the calculation is a worksheet formula or part of a Power Query output table. For a query, confirm the source column names and whether empty values appear as null or empty text.

Solution 1

Return a Blank with an Excel Worksheet Formula

Use an IF formula when the calculation is performed in a worksheet cell.

1
Enter the formula

Select the result cell and enter =IF(G1="","",G1-F1). Adjust the row and column references to match your data.

2
Check the result

Leave G1 empty to confirm the formula displays a blank; enter a value in G1 to calculate G1 minus F1.

Blank result: The formula returns an empty text string, not a Power Query null value.
Free Microsoft Office alternative

Work with Spreadsheet Formulas in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. Use WPS Spreadsheets for worksheet formulas; it does not fix Excel Power Query behavior.

Use IF formulas to display blank results for empty source cells.Open and edit Microsoft Excel XLSX and XLS files.Work in a familiar spreadsheet interface that makes migration easier.Use a free, lightweight office suite for everyday documents and spreadsheets.
microsoft office alternative - wps office

Frequently Asked Questions

How do I make an Excel formula show blank when G1 is empty?

Enter =IF(G1="","",G1-F1) in the result cell. The formula returns an empty text string when G1 is empty.

Will a Power Query custom column remain after refresh?

Yes. Add the calculation through Add Column > Custom Column in Power Query Editor, then select Home > Close & Load. The query reapplies the transformation when refreshed.

How can I stop Excel from copying a formula down a table column?

Immediately after the automatic fill, use Undo or select the AutoCorrect Options button and choose Stop Automatically Creating Calculated Columns.

Is an Excel formula blank the same as a Power Query null?

No. The worksheet formula =IF(G1="","",G1-F1) returns an empty text string, while a Power Query custom column can return null.

Will manually entered data stay aligned with Power Query rows?

Not necessarily. A refresh can change the query output, so manually added worksheet data may no longer correspond to the same rows. Where possible, add the calculation in Power Query instead.