Top.Mail.Ru
Home Catalog

How to Write an Excel Formula Using AI

We show how to easily and quickly generate a formula for Excel or other spreadsheets using the AI-powered service Formularizer, explore its features, and test it in action.

Article category

Introduction

Formulas are an essential tool when working with Microsoft Excel. Previously, we compiled a selection of AI tools for spreadsheets, which you can check out here: neuro.pizza/articles/neuroseti-dlya-tablic. In this article, we will demonstrate everything with a real example.

Which AI tool will we use?

We will test Formularizer AI, available at formularizer.com/home. Keep in mind that the free version allows generating up to 50 different formulas per month. The service supports not only Excel but also Google Sheets.

Creating a formula request

Enter in the input field what the formula should do. You can write in plain language. As an example, we will ask the AI to create a simple formula that calculates the sum of columns based on a given condition.

In just a few seconds, we get not only the formula itself but also a detailed explanation of how it works. This can be useful if you want to create something more complex with multiple conditions.

What else can you do with Formularizer?

The service offers more than just formula generation; it also includes other useful tools for working with spreadsheets, such as creating regular expressions (regex) and SQL queries.

The same fast generation with equally detailed explanations. Of course, such functionality is mainly useful for advanced users in specific tasks, but who wouldn't want to simplify and speed up their workflow?