Which tool to choose
For quotes in spreadsheets you have two routes, and the second is almost always the better one.
- Dedicated formula generators are sites where you describe what you want and they give you the formula for Excel or Google Sheets. Handy, but it's an extra step.
- A general-purpose AI assistant does the same work inside the conversation you already use, and on top of that it explains the formula and helps you fix it if it's wrong. For someone who isn't experienced, having someone who explains is worth more than the generator's speed.
The choice of sheet matters less than it seems: Excel and Google Sheets use almost identical formulas. Just tell the AI which of the two you use, and it'll give you the right version.
How to do it
On Excel or Google Sheets the method is the same, only some function names change, which the AI knows.
- Describe to the AI how your quote is made by hand: which columns you have (description, quantity, unit price), how you calculate the row total, whether you apply a discount, whether you add VAT.
- Indicate which sheet you use and in which cells the data is: "I use Google Sheets, the quantities are in column B starting from row 2, the prices in column C." The cell references are what make the formula usable.
- Ask for the formula, not the result. The operational syntax:
I use Google Sheets. I'm making a quote. In column B there are
the quantities (from B2), in column C the unit price (from C2).
Give me the formula for column D that calculates the total of each row
(quantity times price). Then give me the formula for the grand total
with VAT at 22 percent. Explain where to paste them.
- Paste the formula into the first cell indicated, then drag it downward for the other rows (you pull the cell's corner down and the formula copies, adapting itself). If you don't know how to drag, ask the AI: "how do I copy this formula across all the rows?"
- Verify with a case you know: take a quote already done by hand, enter the same numbers, and check that the automatic total matches yours. If it matches, the formula is right.
- Feedback: if the result is strange (an error like
#VALUE!or an absurd total), paste the formula and what happened into the AI: "I put this formula and it gives me this error." Almost always it's a cell reference or a semicolon out of place.
A concrete example
Elena has a cleaning business and redoes every quote by hand on the calculator: square meters times rate, plus a fixed travel cost, minus the discount for regular customers. She often gets it wrong and loses time over it.
She describes the calculation to the AI for Excel. The AI gives her three formulas to paste: one for the cleaning cost, one to add the travel, one to subtract the discount as a percentage. It explains where to put them.
=B2*C2 (square meters times rate = cleaning cost)
=D2+E2 (cleaning cost plus travel)
=F2*(1-G2) (total minus the discount, where G2 is the percentage, e.g. 0.1 for 10 percent)
Elena pastes them, tests with an old quote: the total matches. Now she enters only square meters and discount, the rest calculates itself. From ten minutes on the calculator to thirty seconds, with no more careless errors.
When it does NOT work (and how to fix it)
If the formula gives an error like #VALUE! or #NAME?
These are the two most common errors. #VALUE! usually means you're multiplying a cell that contains text instead of a number (for example "5 sqm" instead of 5). #NAME? means a function name is misspelled or doesn't exist in your language. Paste the formula and the exact error into the AI: "it gives me #NAME?, what's wrong?"
If the AI gives you a formula with a comma but your sheet wants a semicolon
It's a classic trap: depending on the sheet's language, the arguments of a formula are separated with a comma or a semicolon. If you paste it and it gives an error, ask: "my Google Sheets is in Italian, rewrite the formula with the right separators for the Italian version." It's a detail that blocks many people.
If the totals are right but change on their own when you add rows
It means the grand total formula doesn't include the new rows. Instead of a row-by-row sum, ask the AI for a formula that sums an entire column even if you add rows below: "give me a formula that totals all of column D, including the rows I'll add in the future." It exists and it's called a range sum.
If the quote is complicated and a single formula isn't enough
When there are tiered discounts, different prices per customer, or rules with exceptions, a single formula becomes unreadable. Here it's better to break the calculation across several helper columns (one for each step) and have each one explained. Ask the AI: "the calculation is complex, help me split it into several simple columns instead of one giant formula." Several clear columns beat one incomprehensible formula.
A tip from someone who actually uses it
Before trusting the automatic sheet for real customers, test it against numbers you already know: take three or four old quotes done by hand and verify that the sheet gives the same totals. A wrong formula is worse than calculating by hand, because it errs silently and with the air of precision. The sheet earns trust only after it has passed the test of the cases you already know by heart.
Frequently asked questions
Do I have to tell the AI which cell my data is in?
Yes, and it's the detail that makes the difference between a generic formula and one ready to paste. If you say "the quantities are in column B, the prices in column C," the AI gives you the exact formula. If you don't say it, it gives you an example you'll have to adapt by hand, with more risk of getting it wrong.
Can I also have a complete quote template created from scratch?
Yes. Describe what you sell and ask the AI to design the sheet's structure: which columns are needed, where the formulas go, where the header with your logo. It gives you the layout and the formulas; you build the sheet following its instructions. For the graphic look and the logo you handle it yourself: the AI structures the calculation, not the design.
Can the AI connect to my sheet and work inside it on its own?
In some cases yes, with tools that hook directly into the sheet, but to get started you don't need it. The method of copying the formulas the AI gives you works everywhere, without installing anything and without giving an external service access to your data. Start from there; the automatic connections are a later step.
Don't I risk trusting a calculation I no longer control?
It's the right fear, and the answer is not to stop checking but to change what you check. Once you've verified the formula on the known cases, you no longer have to redo the calculation by hand: you just have to check that the incoming data is correct. The automatic sheet doesn't remove the control, it shifts it from the numbers (which it now calculates, with no careless errors) to what you input. Whoever errs, from that moment on, is no longer the formula: it's you, if you enter a wrong quantity. And that's a much easier error to spot.