Finding the right function with Insert Function in Grid

Nobody remembers all of the roughly 500 functions in a spreadsheet, and nobody needs to. Grid by Zaweba gives you two ways to find and fill in a function without memorising anything: Insert Function, which you open from the fx button, and the autocomplete and argument tip that appear while you type in a cell or the formula bar.

Browsing with Insert Function

Insert Function lists the functions by category: maths and trig, statistics, financial, date and time, lookup and reference, text, logical, information, engineering, database and the rest. Pick a category and scroll, and each function shows a description of what it does and the arguments it takes. It's the quickest way to answer "is there a function that does this?" when you know the job but not the name.

Choose a function and the Function Arguments dialog opens. Each argument has its own box, so you fill them in one at a time, clicking cells on the sheet to supply ranges. As you go, the dialog shows live results, so you can see what the function gives back before you commit it to the cell. If the answer looks wrong, you know which argument to look at.

This is especially helpful for functions with many arguments, such as the financial ones, where the order matters and a missed comma shifts everything along. It's also a good way to learn: open a function you've never used, try a few inputs and watch the result change.

Typing with autocomplete

Once you know roughly what you want, typing is faster. Start a formula with an equals sign and the first letters of a name, and autocomplete offers matching functions. It offers names you've defined and tables in the workbook too, so a named range or a table called Sales is only a couple of keystrokes away.

After the opening bracket, a tip appears showing the function's arguments, with the one you're on in bold. Type a comma and the bold moves to the next. That small cue prevents a lot of mistakes, because it tells you at a glance whether you're filling in the rate or the number of periods, the lookup value or the return range.

As you type references, Grid colours them in the formula and draws matching coloured boxes on the grid, so you can see exactly which cells the formula is pointing at. Press F4 on a reference to cycle the dollar signs that fix its row, column or both.

Good habits

Use Insert Function when you're exploring and typing when you're confident. Read the description before relying on a function you haven't used, particularly in statistics, where similar names can mean a sample or a whole population. Check the live result in Function Arguments against a figure you can work out by hand, at least the first time.

When a formula already exists and you want to understand it, click into it and the argument tip appears again for whichever function the cursor is inside. That's often quicker than unpicking a long formula from left to right.

How it fits with the rest of Grid

Names and tables make formulas easier to read, and because autocomplete offers them, they're also easier to type. A workbook with a named tax rate and a table of products ends up with formulas that read almost like sentences. If you've connected your own AI account, the AI menu can also write, explain or fix a formula, and every suggestion is checked by Grid's own engine before you can insert it.

Between the category list, live results and the argument tip, Grid by Zaweba makes its large function library approachable, whether you're writing your first SUM or your first LAMBDA.