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.

Where is the Formula for OneNote Table OneNote table formula is hidden in the second Gem tab.

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

Then, you will find Table Tools tab set appear on the OneNote ribbon, there are 2 hidden tabs are shown in Table Tools set, they are Layout and Gem ( the second Gem tab ).

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.

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.

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.

Columns In Onenote For Mac