How to look up a function in Numbers on Mac with Formulas and Functions Help

Apple keeps the function reference inside Numbers, so you do not need a web search to learn what a function does. The Help menu opens Formulas and Functions Help. The Functions Browser lists every function while you build a formula. The Numbers User Guide for Mac says it covers Numbers 15.4, so check your version first.

Open Formulas and Functions Help from the Help menu

Click Help in the menu bar at the top of the screen. Then choose Formulas and Functions Help. Apple's page explains how to use formulas and functions in your spreadsheet. It also covers the argument types, condition types, and wildcards that formulas accept.

Read the condition and wildcard sections before you guess at a format. A function that counts or matches values often needs its condition written in a specific way.

Check how many functions the guide lists

Apple's heading on that page says Explore more than 300 functions. The iCloud guide for Numbers says more than 250 built-in functions. Apple's web guide says hundreds. Those figures conflict, and the pages checked do not say which one is current.

Treat the total as a rough guide. What matters more is that the browser lists each function with its arguments. You do not need to memorize the count.

Search the guide on the web version

Apple's web version of Formulas and Functions Help has a Table of Contents link at the top of the page. It also has a Search this guide field. Those controls are documented for the web guide.

The Mac Help window may show the same controls, but this guide could not confirm that. If you do not see a search field, use the Table of Contents or your browser's find feature. Apple lists COT among the functions added in Numbers 15.4, so it is a good test. If COT is missing from your Functions Browser, your version may be older.

Look up a function from inside a cell

Most people look up a function while they type a formula. Click an empty cell, then type an equal sign (=). The Formula Editor opens over the cell.

The Functions Browser appears on the right side of the window and lists all functions. Apple's iCloud guide places the browser in the sidebar instead. Look for a list of functions and a search field, wherever your window shows them.

Find the function in the Functions Browser

Click the search field at the top of the Functions Browser. Type a function name or a related term. Apple's example is the word address. Searching by task works when you do not know the exact name.

Here is a worked example. Say you need the cotangent of a value. Type COT in the search field, and the list narrows. Double-click COT. It lands in the Formula Editor with its arguments, ready for values.

Insert a function from the toolbar instead

You do not have to start in a cell. Click the Insert button in the toolbar, then choose New Formula. This opens the Formula Editor and the Functions Browser, just like typing an equal sign.

This route helps when you want to browse functions before you commit to a cell. It is also the quickest route if you are not sure where the result should go.

Read the arguments and fill them in

Double-clicking a function puts it in the Formula Editor with its required and optional arguments. Required arguments must get a value. Optional arguments can stay empty, or you can add them when you need them.

Apple's notes list three keys that matter here. Command-K preserves both the row and column of a selected range. Delete removes selected cell references. Return commits the formula.

• Command-K: preserve both the row and column of a selected range
• Delete: remove selected cell references
• Return: commit the formula
• Commit Formula button: finishes the formula, the same as Return

Apple lists no Option, Control, or Shift shortcuts for the Formula Editor. Do not spend time searching for them.

Read the error triangles in a result cell

A formula error shows a red triangle in the middle of the result cell. A blue triangle in the upper left means one or more warnings. Click either icon to open a message window that summarizes each error and warning.

If the message points to another cell, click that cell reference in the message to select it. Then you can see which input caused the problem. Read the message before you change anything.

Fix a broken formula and commit it again

Double-click the result cell. The Formula Editor reopens with your formula. Change, remove, or add references as needed.

Press Return or click the Commit Formula button. Check the result cell. If the red triangle stays, click the icon again and read the new message.

Common causes of formula errors in Numbers

Apple lists six common causes. Check these before you rebuild the formula from scratch.

1. Typos or invalid cell references in the formula
2. Self-reference, where a formula refers to its own cell
3. Text that is not in double quotation marks
4. Numbers stored as text, fixed by setting a numeric format in the inspector
5. A deleted cell that the formula still refers to
6. References that shifted after you inserted a row or column

Text is the sneaky one. A number that looks right can fail if Numbers stores it as text. Select the cell, open the inspector, and set a numeric format.

This guide found no Apple-documented fix for #NAME? errors. The Apple pages checked do not cover that message, so this guide does not give one.

Which Numbers version adds the newer functions

Numbers 15.4 requires macOS 26 or later. It adds 18 functions, including trigonometry, statistics, and logic functions. Examples include COT, GAMMA, PEARSON, XOR, and DAYS.

Numbers 14.4 added over 30 functions earlier. Those include LET, LAMBDA, FILTER, SORT, and UNIQUE. It also added spilling arrays, so one formula result can fill several cells.

To check your version, open Numbers > About Numbers. If your version is older than 15.4, the newest functions may not appear in the browser. Match your version to the guide before you troubleshoot.

What Apple Creator Studio changed in Numbers 15.1

Numbers 15.1 became part of Apple Creator Studio. Apple says creating, viewing, editing, and real-time collaboration do not need a subscription. Content Hub and generative AI image tools do.

The subscription details do not change the Help menu or the Functions Browser, as far as Apple's pages describe.

Mistakes people make when they look up a function

• Skipping the equal sign. Without it, you have typed text, not a formula.
• Ignoring the argument names. They show what each input expects.
• Typing a text value without double quotation marks around it.
• Trusting results after inserting a row or column. Apple lists shifted references as a cause of errors.
• Assuming every Apple page shows the same function count or the same browser layout.
• Clicking the red triangle, reading nothing, and deleting the formula.

Keyboard shortcuts in the Formula Editor

Return does most of the work. It commits the formula, and it is usually the last key you press. Command-K and Delete help you select and change references.

The Apple pages checked do not list a keyboard shortcut for opening Formulas and Functions Help or the Functions Browser. Use the Help menu and the toolbar for those.

Next steps after you find the function

Once the formula works, you may want to sort the rows that feed it. The guide on how to sort a table in Numbers on Mac by column walks through that step.

For more on Numbers features, see the Numbers page for Mac. Use Apple's guide as the final check when a function behaves differently from what you read here.