Every feature in Nought
A native Mac spreadsheet with 200+ formulas, 7 chart types, full formatting, and real .xlsx support. Here is everything it can do.
200+ formulas
Autocomplete shows every function as you type. Cross-sheet references, named ranges, and dynamic array spill are all supported.
Math
SUM, SUMIF, SUMIFS, SUMPRODUCT, AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, POWER, SQRT, ABS, RAND, RANDBETWEEN, CEILING, FLOOR, LOG, LN, EXP, PI, RADIANS, DEGREES, SIN, COS, TAN, ASIN, ACOS, ATAN, ATAN2, SIGN, TRUNC, QUOTIENT, PRODUCT, SUBTOTAL, AGGREGATE
Statistical
MEDIAN, MODE, STDEV, VAR, LARGE, SMALL, RANK, PERCENTILE, PERCENTRANK, QUARTILE, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, T.DIST, BINOM.DIST, POISSON.DIST, CONFIDENCE, CORREL, COVARIANCE, FORECAST, SLOPE, INTERCEPT, RSQ, GROWTH, TREND
Lookup & Reference
VLOOKUP, HLOOKUP, INDEX, MATCH, XMATCH, XLOOKUP, OFFSET, INDIRECT, ADDRESS, ROW, COLUMN, ROWS, COLUMNS, CHOOSE, TRANSPOSE
Text
CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, REPLACE, TRIM, CLEAN, UPPER, LOWER, PROPER, REPT, TEXT, VALUE, EXACT, TEXTSPLIT, CHAR, CODE, FIXED, DOLLAR, T
Date & Time
TODAY, NOW, DATE, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, WEEKDAY, WEEKNUM, EDATE, EOMONTH, NETWORKDAYS, WORKDAY, DATEDIF, DATEVALUE, TIMEVALUE, DAYS, DAYS360, ISOWEEKNUM
Logical
IF, IFS, AND, OR, NOT, XOR, IFERROR, IFNA, SWITCH, TRUE, FALSE
Financial
PMT, PV, FV, NPV, IRR, RATE, NPER, SLN, SYD, DB, DDB, PPMT, IPMT, EFFECT, NOMINAL
Engineering
DEC2HEX, DEC2BIN, DEC2OCT, HEX2DEC, HEX2BIN, HEX2OCT, BIN2DEC, BIN2HEX, BIN2OCT, OCT2DEC, OCT2HEX, OCT2BIN
Array & Dynamic
VSTACK, HSTACK, WRAPROWS, WRAPCOLS, TOCOL, TOROW, TAKE, DROP, CHOOSECOLS, CHOOSEROWS, MAKEARRAY, SORT, SORTBY, FILTER, UNIQUE, SEQUENCE, RANDARRAY
Info & Error
ISBLANK, ISERROR, ISNA, ISNUMBER, ISTEXT, ISLOGICAL, ISFORMULA, TYPE, N, NA, ERROR.TYPE, CELL, INFO
7 chart types
Insert from the toolbar with a live preview. Charts survive .xlsx round-trip and render in PDF export. Interactive tooltips on hover.
Bar / Column
Vertical and horizontal bar charts for comparing categories. Supports stacked and grouped layouts.
Line
Connect data points over time or ordered categories. Multiple series with distinct colors.
Pie
Show proportional distribution of a single data series. Labels with percentages.
Area
Like line charts with filled regions beneath. Good for showing volume over time.
Scatter
Plot X-Y data points to reveal correlations. Supports trendlines: linear, exponential, moving average.
Combo
Mix bar and line series in a single chart. Useful for comparing metrics on different scales.
Waterfall
Show how an initial value is affected by sequential positive and negative changes.
Data tools
Sort, filter, validate, and analyze your data without leaving the app.
Sort
Single-column sort from the toolbar or context menu. Multi-key sort dialog with up to three keys, header detection, and case sensitivity.
Auto-filter
Per-column dropdown arrows in the header row. Check or uncheck values to filter the visible rows instantly.
Conditional formatting
17 rule types: greater than, less than, between, equal to, text contains, top N, duplicates, color scales (2-color and 3-color), data bars, and icon sets.
Data validation
Restrict cell input to whole numbers, decimals, dates, text length, or a dropdown list. In-cell dropdown arrow for list validation.
Named ranges
Define names for cell ranges and use them in formulas. Workbook or sheet scope. Name Manager dialog for editing.
Find and replace
Search across all cells with options for case sensitivity, whole-cell matching, and formula search. Replace one at a time or all at once.
Remove duplicates
Select which columns to check and remove rows with duplicate values.
Text to columns
Split a single column into multiple columns using a delimiter (comma, tab, semicolon, space, or custom).
Goal Seek
Find the input value needed to reach a target result in a formula.
Subtotals
Insert automatic subtotal rows grouped by a column, with SUM, AVERAGE, COUNT, MIN, or MAX.
Pivot tables
Summarize large datasets by dragging fields into rows, columns, values, and filters.
Sparklines
Tiny charts rendered inside a cell. Line and bar types. Configure data range and placement.
Formatting
Full cell formatting with undo support for every action.