Entering formulas in the worksheet

Note:

If you create a formula that references an amounts total, make sure it references a Total cell, not an Amounts cell. This makes the formula more robust, especially if the Amounts row is summarized and you later decide to change it to itemized.

To enter formulas in the worksheet

Enter a formula. Ajera supports common spreadsheet formulas. For example:

For this formula type

Do this

Amount totals of adjacent rows

Click a row.
Click the Total button to automatically create a formula that sums the values of all the amount cells between the current row and the preceding Total row or Column Setup row for each defined column. For example: =SUM(B8:$B$9)
In the Format group of the toolbar, select Currency.
Click the increase precision or decrease precision button in the Format group of the toolbar, as needed.

Amount totals of nonadjacent rows

Double-click a cell.
Press the equals (=) key.
Enter a formula that sums the values of selected amount cells. Separate nonadjacent rows with a comma. For example: =SUM(B8, B11, B13).
In the Format group of the toolbar, select Currency.
Click the increase precision or decrease precision button in the Format group of the toolbar, as needed.

Percentages

Double-click a cell.
Press the equals (=) key.
Enter a formula that divides the values of selected cells to determine a proportion in relation to a whole (usually 100). For example, =B5/$B$9.
In the Format group of the toolbar, select Percent.
Click the increase precision or decrease precision button in the Format group of the toolbar, as needed.

Ratios

Double-click a cell.
Press the equals (=) key.
Enter a formula that divides the values of selected cells to determine how many times the first quantity is contained in the second quantity. For example, =D9/D25.
In the Format group of the toolbar, select Number.
Click the increase precision or decrease precision button in the Format group of the toolbar, as needed.