Ask AI to give you a ready-made formula and clear steps. Return JSON {"task":"...","columns":"...","wantFormula":"..."}: task — what needs to be counted in words; columns - which column is responsible for what (letter - meaning); wantFormula - ask for the formula itself, and an explanation of each part of it in simple language, and where to insert it.
AI will write the formula correctly only if it knows the layout of the columns: which letter means what and where the result is placed. Without this, he will come up with names at random, and the formula will not be inserted or will calculate the wrong thing. Mechanics: a formula is an instruction “take a cell from here, subtract from there,” and the AI collects it from your description of the columns. Levers: name the columns with a letter and meaning (B - balance at the beginning, C - income, D - expense), tell which cell the result goes into, specify “stretch down to the last line”. Insider: ask to explain the formula in parts - “what each bracket does.” Then the next time you change the table, you will correct it yourself, and not run to AI. Second trick: ask FIRST to calculate one line by hand as an example, and give the formula after. If the example is incorrect, the error can be seen immediately, before you stretch it 200 lines. A typical mistake: asking for a “formula for the remainder” without saying where the data is, and you will get =B2-C2 at random, although you have income and expenses in other columns.
Unlock access to submit solutions for instant AI review.