Writing a Spreadsheet formula can be challenging and even the most savvy spreadsheet guru can get stuck on a syntax or formatting error. The Coefficient Team is here to help with this handy guide. 🙌🏼

Formula Builder Best practices

Everyone loves tips and tricks to become the SME (Subject Matter Expert) on the latest tech. Here are some great tips to wow your colleagues and peers. 😎

Be specific: Provide a clear and specific description of the task/problem you want to solve with the formula.
Keep it simple: Avoid using overly complex or hyper-technical language in your prompt.
Provide context: Provide any necessary context or background information that can help ChatGPT understand the problem you are trying to solve.
Test the formula: Test the formula thoroughly to ensure that it works as expected and produces accurate results.

The beauty of GPT is its flexibility in understanding prompts. You’re not confined to a specific format or structure.

Math Formulas

GPT can assist in generating mathematical formulas in Google Sheets, saving time and effort by eliminating the need to manually input complex formulas and offering suggestions and corrections to ensure accuracy. Utilizing GPT for math formulas can streamline the process of creating and managing mathematical data.

Example use case	Count how many customers are on the Business Storage Plan.
Example Prompt	Count the number of rows that have 'Business' in column C.

<aside> 📝 Click here to see this example in a spreadsheet

</aside>

Screen Recording 2023-04-28 at 12.03.03 PM.mov

More Math Prompt Examples:
Determine the difference in sales revenue between this year and last year.
Figure out how much the company spent on advertising in Q1 2023.
What is the total revenue generated by multiplying the quantity sold of each product by its sale price?