Generate formula columns with Copilot in Excel
Not sure how to write a formula for a new column? Microsoft 365 Copilot can help!
Formula columns are a way to add new columns to your table that perform calculations based on other columns in your data. For example, you might use a formula column to calculate the total cost per product, or to calculate the profit for each marketing campaign. With formula columns, you don't need to manually enter calculations for each row in your table. Instead, you can let Copilot quickly add new columns with formulas based on your data.
-
With your data formatted as a table, select the Copilot button in the ribbon.
-
Select Add formula columns or Show suggestions for formula columns. You can also describe what columns you’d like to add by typing it in your own words.
-
Copilot provides formula suggestions with an explanation on how each formula works. View the explanation by selecting Explain formula.
-
Select Insert column to add the formula column to your table.
Note: As with any AI-generated content, it’s important to review, edit, and verify anything Copilot creates for you.
Give it a try
Use these prompts as a starting point. Copy and modify them to suit your needs.
-
Calculate total cost per product in a new column.
-
Add a column that calculates the total profit for each marketing campaign in 2022.
-
Add a column that calculates the number of days after the product launch event.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
