Every calculation in RixSheets runs through a full formula engine built into the app: math, statistical, financial, logical, lookup, text and date-time functions, hundreds of them, evaluated locally with the syntax you already know. Whether you need SUMIFS to total one region, VLOOKUP or INDEX/MATCH to pull a matching record, or IRR, NPV and PMT for investment math, you write the same formula you would write anywhere else — and RixSheets gives you the Insert Function dialog, a formula view mode and trace arrows to keep the whole thing auditable.
The function library at a glance
The engine groups its functions the way finance and operations teams actually think:
| Category | Examples | Typical use |
|---|---|---|
| Math | SUM, SUMIFS, ROUND, PRODUCT | Totals, conditional sums, rounding |
| Statistical | AVERAGE, COUNTIFS, MEDIAN, LARGE | Averages, counting with criteria |
| Financial | IRR, NPV, PMT, FV | Loan schedules, investment appraisal |
| Logical | IF, AND, OR, IFERROR | Decisions, error handling |
| Lookup | VLOOKUP, INDEX, MATCH | Pulling values from reference tables |
| Text | LEFT, TEXTJOIN, SUBSTITUTE | Cleaning and combining labels |
| Date-time | TODAY, EOMONTH, NETWORKDAYS | Billing periods, aging reports |
There are hundreds more beyond these examples, and they nest freely: an IF can wrap a VLOOKUP, a SUMIFS can sit inside a PMT schedule, and array-style ranges work just as you expect.
Find and insert a function
- Select the cell that should hold the result and press the equals key.
- Either keep typing the function name — autocomplete narrows as you go — or open Insert, Function to bring up the Insert Function dialog.
- In the dialog, search by name or by what you are trying to do. Results include a short description so you can confirm the function does what you mean.
- Select a function and the dialog shows every argument with inline help — what each one expects, in which order.
- Fill the arguments, press Enter, and the completed formula lands in the cell with the result calculated.
The argument help matters most for functions like NPV or SUMIFS, where the order of inputs is easy to mix up. You never have to memorize signatures; the dialog walks you through them.
Review work in formula view mode
Results hide the machinery. Toggle formula view mode and the sheet shows every formula as text in its cell, so you can scan down a column and compare patterns, spot hard-coded numbers that should be references, and check that row 14 really uses the same logic as row 13. It is the fastest way to audit a sheet you did not build yourself. Toggle it off and the values return instantly — nothing about your data changes.
Follow the numbers with trace arrows
When a number looks wrong, select the cell and draw trace arrows for its precedents. Arrows point from every input range into the selected formula, so you can see at a glance whether a SUMIFS is reading the right column, whether a lookup range stops one row short, or whether a total quietly includes a stray cell. Tracing works across the sheet and gives you a map of the calculation instead of a guess.
Building reliable formulas
- Use ranges that can grow: =SUM(B2:B200) survives more edits than =SUM(B2:B20) — or better, name the range in the Name Manager and write =SUM(monthly_units).
- Wrap lookups in IFERROR so a missing key produces a readable blank instead of an error value.
- Prefer INDEX/MATCH when your lookup column sits left of the return column; VLOOKUP handles the classic left-to-right case.
- Keep constants in cells, not inside formulas, so a rate change is a one-cell edit.
Let the AI explain a formula
Inherited a workbook full of nested formulas? Select any cell, open the AI chat panel and ask it to explain the formula. The assistant reads the actual cell contents, walks through each function and argument in plain language, and can suggest a cleaner version. It can also draft formulas for you — describe what you want, such as total units where the region is North and the price is above 50, and it proposes a SUMIFS you can accept or adjust. AI pages are unlimited on every plan, so treat it as a patient colleague.
Performance habits for big sheets
The engine is fast, but the way you build determines how fast it stays as a workbook grows:
- Prefer one lookup table over copied variants. Build a single reference range on a dedicated sheet and point every lookup at it; dozens of near-duplicate VLOOKUPs against scattered ranges are the usual source of both slowness and drift.
- Use SUMIFS rather than long IF chains for conditional totals — criteria functions evaluate efficiently, and the formula stays readable six months later.
- Sort and deduplicate reference tables once, then leave them stable; lookups against a clean range are faster and more correct.
- Name the ranges you reuse so recalculation stays predictable when columns move; see the next guide for the mechanics.
- Audit before you copy. Formula view mode plus trace arrows on one representative row beats debugging the same mistake pasted fifty times down a column.
None of this is exotic; it is the same discipline this guide teaches, applied before the sheet grows instead of after.
What to explore next
- Name Manager and Go To — named ranges make formulas shorter and safer.
- Pivot tables in RixSheets — when a summary outgrows SUMIFS.
- RixSheets AI chat panel — explain, draft and audit formulas conversationally.