4sheetx.com — Free Online Spreadsheet with Formulas

Formulas

• =A1+B1 — arithmetic with + - * / and parentheses
• References & ranges: A1, B2, A1:A10
• Absolute references with $: $A$1 (lock both), $A1 (lock column), A$1 (lock row) — kept fixed when you drag-fill

Statistics

• =SUM(A1:A10) — sum a range
• =AVERAGE(A1:A10) — average (mean) of a range
• =MEDIAN(A1:A10) — middle value
• =MIN(A1:A10) / =MAX(A1:A10) — smallest / largest
• =COUNT(A1:A10) — count numeric cells
• =PRODUCT(A1:A10) — multiply all values
• =STDEV(A1:A10) / =VAR(A1:A10) — standard deviation / variance

Math

• =ROUND(x, digits), =ROUNDUP(...), =ROUNDDOWN(...)
• =ABS(x), =SQRT(x), =POWER(x, y), =MOD(a, b)
• =LOG(x, base), =LN(x), =LOG10(x), =EXP(x)
• =FLOOR(x), =CEILING(x), =INT(x), =SIGN(x), =PI()

Trigonometry

• =SIN(x), =COS(x), =TAN(x) (radians)
• =RADIANS(deg), =DEGREES(rad)

Logic & nesting

• =IF(A1>10, 100, 0) — compare with > < >= <= = <>
• Nest functions, e.g. =ROUND(AVERAGE(A1:A10), 2)
• #CIRC = circular reference, #ERR = invalid math

Keyboard shortcuts

• Arrow keys — move selection
• Enter — edit cell / confirm and move down
• Tab — confirm and move right
• Esc — cancel edit
• Delete / Backspace — clear selected cell
• Start typing on a selected cell to overwrite it

Toolbar

• — bold, italic, underline
• — text color, fill color
• — text alignment
• / Row / Col — add or remove a row or column
• Clear cell — clears only the selected cell
• Clear all — clears every cell and format on the sheet

Mouse

• Double-click a cell to edit it
• Drag the small handle at the corner of the selected cell to fill / extend a pattern