Reference

Formula & shortcut reference

Everything the Scrim grid understands - the same functions and muscle memory you use in Excel. Keep this open in a tab while you build.

Math & statistics

SUM

=SUM(B4:B8)

Adds every value in the range.

AVERAGE

=AVERAGE(B4:B8)

Arithmetic mean of the range.

MIN / MAX

=MAX(B4:B8)

Smallest / largest value.

COUNT

=COUNT(B4:B8)

How many numbers are in the range.

PRODUCT

=PRODUCT(B4:B6)

Multiplies the values together.

SUMPRODUCT

=SUMPRODUCT(B4:B6,C4:C6)

Multiplies pairs, then sums - great for weighted averages.

ROUND

=ROUND(B9,2)

Rounds to the given number of decimals.

ABS

=ABS(B9)

Absolute value.

SQRT / POWER

=POWER(1+B5,B6)

Square root / x raised to n. ^ also works: (1+B5)^B6.

LN / EXP

=LN(B9)

Natural log / e^x.

Logical

=IF(B9>0,B9,0)

Returns a when the test is true, otherwise b.

AND / OR

=IF(AND(B5>0,B6>0),1,0)

Combine conditions.

NOT

=NOT(B5>0)

Flips true/false.

Comparisons

=B5>=B6

Return true/false; use inside IF.

Finance

NPV

=NPV(B5,B10:F10)

Present value of a series of future cash flows.

IRR

=IRR(B10:F10)

Rate that makes NPV zero (include the negative outlay).

PV / FV

=PV(B5,B6,B7)

Present / future value of an annuity.

PMT

=PMT(B5,B6,B7)

Level payment that pays off pv over n periods.

NPER / RATE

=NPER(B5,B7,B8)

Number of periods / implied rate.

CAGR

=CAGR(B4,B9,5)

Compound annual growth rate over n years.

Keyboard shortcuts

Move between cellsArrows

Jump to the edge of the dataCtrl + Arrow

Extend the selectionShift + Arrow

Edit the active cellF2 / double-click

Confirm and move down / rightEnter / Tab

Copy / paste (works with real Excel)Ctrl + C / V

Fill down / rightCtrl + D / R

Undo / redoCtrl + Z / Y

Insert a reference (point mode)= then click a cell

Absolute reference, e.g. =B15*$B$6$

Ready to use these for real?

Open the simulator