Summary  
This chapter covers using AI to automatically generate and apply data-manipulation formulas from natural-language descriptions, eliminating the need to remember exact syntax.  

General domain of usage  
Spreadsheet data analysis


Writing formulas can be confusing, especially when you do not remember the exact syntax.
Gemini helps you create formulas based on what you want to achieve.





## Situation

You are working with a table of expenses.
You need to calculate the difference between planned and actual values and flag overspending.

You know the logic, but you do not want to spend time writing formulas manually.





Inside Google Sheets, you describe what you need.



Create a formula to calculate the difference between planned and actual spending in each row. Also, mark rows where actual spending is higher than planned.

Prompt

Gemini generates the formula and applies it to your data.






You get working formulas without remembering syntax.
The logic is applied directly to your table.


You describe what you want, and Gemini creates it.



Discover how to use Gemini across Google Workspace to handle everyday work tasks faster. Write emails, create documents, analyze data, build presentations, manage meetings, and find information across files using practical workflows. Focus on real scenarios and clear results while reducing manual work and saving time.

Explore how Gemini works inside Google Workspace and where it appears across your daily tools.
Understand how access and pricing work, and what affects availability in your account.

Explore how to write, reply, and manage emails faster using Gemini inside Gmail.
Turn notes into structured messages, respond using thread context, and summarize long conversations. Focus on communication, not formatting, while keeping emails clear and professional.


Generate, improve, and structure documents faster using Gemini inside Google Docs. Rewrite messy content, summarize long text, and adjust tone and structure for professional results. Focus on clarity and readability while reducing manual writing and editing.

Create tables, clean data, and build formulas faster using Gemini in Google Sheets. Analyze datasets, extract insights, and turn numbers into clear reports.
Focus on decisions and results instead of manual data work.

Generate slide content, convert existing text into slides, and simplify presentation content using Gemini in Google Slides. 

Capture conversations, summarize meetings, and extract action items using Gemini in Google Meet. Turn discussions into clear notes, tasks, and follow-ups without manual note-taking. Focus on participation during meetings while Gemini handles documentation and next steps.

Find files, ask questions, and extract key information using Gemini in Google Drive. Compare documents, summarize content, and combine insights from multiple sources. Focus on getting answers and building clear outputs instead of searching through files.

Creating Formulas with AI

Situation