Example: AVERAGE(C3,C4,C5) Result: 73.67 COUNT(Expr) Calculates the count of items identified inside the parentheses.

You can perform calculations and logical comparisons in a table by using formulas.

It will appear when you select a table in current OneNote page.

On the Table Tools - Gem tab - Formula group - Click Formula.

It help format the number of the formula result and display in the table cell.

If you have selected multiple table cells, Gem will save the formula to the selected cells, it also auto taking account of any relative references you had in the original formula.

For Example: Insert formula D2B3-C3 into cells from D3 to D14 The relative formula are.

Remove the Cell Formula If you want to remove the formula from cell, select the cell, click Delete feature on OneNote ribbon, it will remove the formulas from selected cells.

Highlight the Formula Cells If you want to find out which cells contain formula, click the Formula Cells feature on the OneNote ribbon, it will select all the formula cells in the table.

Update Formula Results If you change some of the number in table, the formula dont automatically recalculate the results, you need to manually to update them.

Click Recalculate feature on the OneNote ribbon, it will recalculate all the formula results in the table.

In this convention, the letter refers to the cells column and the number refers to the cells row.

The first column in a table is column A; the first row is row 1.

The following table contains examples of this reference style.

The cell in the first column and the second row A2 The first two cells in the first row A1,B1 All the cells in the first column and the first two cells in the second column A1:B2 The first row 1:1 The first column A:A.

The time is not displayed if the date-time value indicates midnight precisely.

If the m specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.

If the mm specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.

The ampm specifier can use lower, upper, or mixed case, and the result is displayed accordingly.

The ap specifier can use lower, upper, or mixed case, and the result is displayed accordingly.

ABS(Expr) Calculates the absolute value of the value inside the parentheses.

Example: ABS(C3-(D2B3)) Result: 1500.64 AND(Expr, Expr,.) Evaluates whether the arguments inside the parentheses are all 1 or 0.

Example: AND( (C4-C3) 0) Result: 1 AVERAGE(Expr, Expr, ) Calculates the average of items identified inside the parentheses.

Onenote 2016 For Mac Table Sum