OneNote Gem Add-Ins

Gem for OneNote v14 now is extended OneNote table formula feature.  
It's a set of formula commands now. 
They are "Insert Formula", "Delete Formula", "Show Formula Cells", "Recalculate Formula Cells".

The formula cell now can remember the formula and can updatable.

Insert a Updatable Formula:

• Consider the following table where we will have total of the rows. Click in a cell that should contain the sum of a rows. ( put the cursor in a cell )

• Click the "Table Tools" -> "Gem" tab -> "Formula" command.

• In the "Table Formula" dialog
  Function: Sum, Scope: Range, Range: B2:C2, ( Sum range B2 to C2 ), Result number format: $0.00.
  Click the "Calculate" button, will insert this format and result value into the selected cell.

Table Formula Dialog

1. Formula functions: 
   Add, Substract, Average, Count, Sum, Max, Min.
2. Formula calculation scope:
   Row: Left, Right
   Column: Above, Below
   Range:
   a. Calculate Cells:     B2, C2, D2
   b. Calculate Range:  B2:D2
3. Calculation result format: 
   0.00, 0.00%, also support customize output format. ( like "$0.00" )

 

Modify the Cell Formula

If you want to modify cell exist formula, select the cell (put the cursor in the cell), and click "Formula" command again.

Delete the Cell Formula

If you want to delete cell exist formula, select the cell (put the cursor in the cell), and click "Formula" group -> "Delete" command. It will remove the formula from the cell.
 

Show Cells Exists Formula

If a table is exists many formula cells, we can use "Formula" group -> "Formula Cells" command to show them on.

Recalculate Table Formulas

If any cells change in formulas table, we can use "Formula" group -> "Recalculate" command to recalculate exists formulas.

Gem for OneNote v38 improve Table Formula