🏓 How to write the correct formula for Excel and Google Sheets?

AI Excel Bot will help you write a formula to work with data in a spreadsheet or "decode" an existing formula.

❓ How does it work?

1⃣ To create a formula in the Playground section, select the desired program, Excel or Google Sheets, and click Generate.

2⃣Describe your task in the text window: for example, count how many times a particular word appears in the cells.

3⃣ Click on Get Formula, and within a couple of seconds, the AI will generate a response.

4⃣ If you want to understand what your colleague meant by their formula, instead of clicking Generate, click on Explain, paste the formula into the text window, and click Generate.

🧑‍💻 We asked the AI Excel Bot to write a formula to calculate the most frequently occurring value in the range AF1 to AF10. You can see the answer in the illustration accompanying this post.

📁 All requests and formulas are saved in the Archives section.

💵 In the free version, 10 generations per month are available. In the paid version, for $5.99 per month, there is an extension for Google Chrome and an add-on for Excel.

#manual @hiaimediaen