=A1+B2*2/(3-1)Arithmetic: + − * / ^ %, unary minus, parentheses, comparisons = <> < <= > >=, text join &SUM(A1:B5, 10)Adds numbers in ranges and literals. Text is ignored.AVERAGE(A1:A9)Mean of numeric cells. Empty cells excluded. #DIV/0! if none.MIN / MAX(range)Smallest / largest numeric value.COUNT(range)Count of numeric values. COUNTA counts non-empty.IF(A1>10, "hi", 0)Conditional. Third argument optional (defaults to FALSE).ROUND(A1, 2)Round half-away-from-zero to N digits (negatives allowed).ABS · SQRT · POWER · INT · MOD · PRODUCT · CONCAT · LEN · UPPER · LOWER · AND · OR · NOT · MEDIAN · STDEV · PI · TODAYExtra built-ins.Keys
Arrows / Tab / EnterMove. Enter commits and moves down, Tab commits and moves right, Shift reverses.Type anythingStarts editing and replaces. F2 or double-click edits in place.EscCancel edit.Delete / BackspaceClear cell.Ctrl+B · Ctrl+Z · Ctrl+YBold, undo, redo.Ctrl+Home · Ctrl+EndJump to A1 / last cell.Right-clickRow/column operations menu.Errors: #CIRC! circular reference · #NAME? unknown function · #VALUE! bad type · #DIV/0! · #REF! deleted reference · #SYNTAX!