Formulo

Overview

Formulo lets you write one formula and apply it down a column of data. Enter values into up to 4 columns (A–D) and up to 5 named constants (V–Z), and Formulo computes a Result for every row automatically.

Example: Gas mileage — formula A/B, where A = miles and B = gallons. Each row's Result shows miles-per-gallon for that row's numbers.

The Screen, Top to Bottom

Region	What it does
Nav bar	Sheet title (tap to rename), ‹ › arrows to move between sheets, and an “N/M” sheet indicator (tap to open the sheet menu).
Formula bar	Shows = plus your formula. C clears it. The A / Name toggle switches references between letters (A, B, V) and your custom column/constant names.
Constants strip	Five fields, V W X Y Z, for fixed values used in every row's calculation (e.g. π, a price per unit, a conversion factor).
Column headers	A B C D for your data, plus Result. Each has an editable name underneath (default value1…value4).
Grid	Up to 20 numbered rows. Tap a cell to enter a number; the Result column fills in automatically.
Stat row	Pick a summary stat per column — Sum, Min, Max, Mean, Median, Mode, Geometric Mean, Count.
Keypad	On-screen calculator keys for building formulas and entering numbers.

Writing a Formula

1. Tap the formula bar.
2. Type using column letters (A, B, C, D) and/or constants (V–Z), combined with the keypad's operators and functions.
3. The same formula is applied to every row, substituting that row's own A/B/C/D values.

• A/B — simple ratio (e.g. mileage)
• (B*C)/A — cross-multiplication
• A/(π*(B/2)^2) — price per square inch, using π and the diameter

Blank cells are treated as 0. Dividing by zero shows an error in the Result cell rather than crashing the sheet.

Use the A / Name toggle to display your renamed columns (e.g. [Price]) instead of bare letters — handy once you've renamed columns to something memorable.

Keypad Reference

Key(s)	Function
0–9, .	Digits and decimal point
+ − * /	Arithmetic
^	Exponent: a^b
!	Factorial: 5!
√	Square root by default: √(x). Give it two arguments for an n-th root, degree first: √(3,8) = 2 (cube root of 8).
( )	Grouping
, :	Function argument separator / range (A:D = A, B, C, D)
e, π	Euler's number, pi
E	Scientific notation: 5E6 = 5,000,000. Works in number fields (cells and constants) and in formulas — you can also put column/constant letters around it, e.g. AEB means A×10B. Shift for LOG.
LOG (Shift of E)	Base-10 by default: LOG(x). Give it two arguments for a custom base, base first: LOG(2,8) = 3 (log base 2 of 8).
SIN COS TAN	Trig functions, one argument, in degrees
SUM MEAN MAX MIN	Statistical functions over a range or list of values, e.g. SUM(A:D). Argument order doesn't matter.
⇧ (Shift)	Swaps several keys to alternate functions (e.g. SIN→ASIN, MIN→GeoMn, MAX→Mode, E→LOG)
⤺	Undo — restores the value you were editing before your last change
⤓ / ⇱ / ⤒	Minimize, switch to numpad, or maximize, depending on context — see below.
⌫	Backspace / delete

LOG and √ are the only functions where argument order matters (base/degree comes first). SUM, MEAN, MAX, MIN, COUNT, MEDIAN, MODE, and GeoMn take any number of values in any order; SIN, COS, TAN, ASIN, ACOS, and ATAN each take exactly one value.

The Minimize / Numpad / Maximize key

The top-left key changes both its icon and its job depending on what you're doing:

• ⇱ Numpad — the default icon while you're entering a number into a grid cell or constant. Tap it to switch the keypad to a compact 4×4 numpad (digits, ., ÷, ×, −, and a Return key) for quicker numeric entry. Tap the numpad's own switch key to return to the full keypad.
• ⤓ Minimize — shown instead of the numpad icon whenever the formula bar is focused, a selection (rows/columns/constants/etc.) is active, or Shift is on. Tap it to collapse the keypad down to a single row, leaving more of the grid visible.
• ⤒ Maximize — shown whenever the keypad is minimized. Tap it to restore the full keypad.

The Clear Key (C)

The C key clears progressively more each time you tap it, relabeling itself at every stage so you always know what the next tap will do. Doing anything else (editing a cell, switching sheets, etc.) resets it back to the first stage.

Label	Tapping it…
C	Clears the field you're currently editing (a cell, a constant, a name, or the formula bar), if it has text.
#C	Clears every value in the grid (all rows, all columns).
CC	Clears all five constants (V–Z).
AC	Resets the entire sheet — formula, names, constants, and grid — back to a blank default sheet.

Each tap only takes effect once you reach that stage; the label tells you which stage you're on before you tap.

Entering and Selecting Data

• Tap a cell to type a value; press Enter to confirm and jump to the same column on the next row.
• Tap a row number, column letter, constant letter, or stat value to select it. Drag across several to multi-select.
• Once something is selected, a selection bar appears above the keypad with Copy / Cut / Paste (Result and Stat selections are copy-only, since they're calculated, not entered).
• Standard clipboard shortcuts (Cmd/Ctrl+C, X, V) work for selected data, copied as tab-separated text — so you can paste in and out of other spreadsheet apps.

Renaming Columns and Constants

• Tap the small name label under any column letter (A–D) or constant letter (V–Z) to rename it — e.g. change value1 to Price.
• Tap the sheet title in the nav bar to rename the whole sheet.
• Renamed fields show up in formulas when the Name toggle is active.

Working with Multiple Sheets

• Use the ‹ › arrows in the nav bar to step between sheets.
• Tap the “N/M” indicator to open a menu listing all sheets — tap one to jump to it.
• Each sheet keeps its own formula, constants, column names, data, and stats — switching sheets switches all of it at once.
• Tap the ⧉ button next to any sheet in that menu to duplicate it. The copy is inserted right after the original, named “… (copy)”, and becomes the current sheet — a quick way to reuse a formula/constants setup with fresh data.

If you clear a sheet completely (back to blank) and then step away from it with the ‹ › arrows, that blank sheet is automatically deleted — this keeps clutter from piling up after using a sheet as scratch space. It won't delete your first sheet or your only remaining sheet, and jumping via the sheet menu instead of the arrows never deletes anything.

Formulo Lite is limited to 3 sheets and can't import CSVs (it can still export). Clear or delete a sheet to free up a slot, or switch to the full version for unlimited sheets and import.

Settings

Open Settings from the nav bar (tap the left arrow on your first sheet, or via the sheet menu).

• Examples — Add ready-made sample sheets (Gas Mileage, Proportion, Price Comparison, Pizza Price per Square Inch) to see formulas/constants/names in action.
• Display — Toggle a condensed font to fit more decimal digits on screen.
• Force Code Refresh — Reload the latest cached version of the app (Formulo works offline and caches itself locally).
• Navigation — Option to skip the Settings page when paging between sheets.
• Import — Load a Formulo CSV export; choose which sheets to bring in and where to insert them.
• Export — Pick sheets and download them as a CSV file (title, formula, constants, and data all included).
• Erase All Sheets — Wipes everything back to one blank sheet. This cannot be undone — use with care.

Data and Backups

Everything is saved automatically to your browser's local storage — no account or internet connection required after the first load.

Because data lives only in that browser, export to CSV periodically if you want a backup or want to move sheets to another device/browser.

For the best experience on mobile, add Formulo to your home screen as an installable app.

Quick Tips

• Start from an Example sheet in Settings if you're not sure how formulas/constants fit together.
• Use constants (V–Z) for anything that doesn't change row to row (a tax rate, π, a conversion factor) — keep data that does vary in columns A–D.
• If a Result shows an error, check for a divide-by-zero or a typo in a column/constant reference.
• Use the Stat row to get a quick Sum/Mean/Max etc. across a whole column without writing a second formula.

Support & Privacy

Support · Privacy Policy