Srodne teme
×
Prijavite se pomoću Microsoft naloga
Prijavite se ili kreirajte nalog.
Zdravo,
Izaberite drugi nalog.
Imate više naloga
Odaberite nalog pomoću kojeg želite da se prijavite.
engleski
Žao nam je. Ovaj članak nije dostupan na vašem jeziku.
Generate formula columns with Copilot in Excel

Not sure how to write a formula for a new column? Copilot for Microsoft 365 can help!

Formula columns in Copilot for Microsoft 365 allow you to create new columns in your table that perform calculations based on existing 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. 

Try it

  1. Open Excel in Microsoft 365.

  2. Open a workbook stored on OneDrive or SharePoint.

    Note: Your data must be formatted as a table. See Format an Excel table for additional information. 

  3. From the Home tab, select the Copilot button on the ribbon. 

    Copilot in Excel icon on the ribbon.

  4. Select Add formula columns or Show suggestions for formula columns from the Copilot chat panel on the right-hand side. You can also describe what columns you’d like to add by typing it in your own words.

  5. Copilot provides formula suggestions with an explanation on how each formula works. View the explanation by selecting Explain formula.

  6. 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. 

Learn more

Copilot help & learning

Get started with Copilot in Excel 

Da li vam je potrebna dodatna pomoć?

Želite još opcija?

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.

Find solutions to common problems or get help from a support agent.

Da li su vam ove informacije koristile?

Šta je uticalo na vaše iskustvo?
Kada kliknete na dugme Prosledi“, vaše povratne informacije će se koristiti za poboljšanje Microsoft proizvoda i usluga. Vaš IT administrator će moći da prikupi ove podatke. Izjava o privatnosti.

Hvala vam na povratnim informacijama!

×