Search
OneNoteGem
  • Home
  • Addins
    • Windows Office Addins >
      • Gem for OneNote
      • OneNote Search Bar
      • OneNote Gem - Favorites
      • OneNote Batch
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • Row to OneNote
      • Auto OneNote
      • Favorite to OneNote
      • Bridge for EndNote and OneNote
      • Anchor to OneNote
      • Anchor to OneNote for PDF
      • Bring to OneNote
      • Gem Table for OneNote
    • Windows UWP Addins >
      • Gem Menu for OneNote UWP
      • CiteBoard for OneNote
      • OneReader
      • OneMind for Windows OneNote
      • OneNote Reminder Cloud (UWP)
      • OneNote Batch Cloud (UWP)
    • Mac Addins >
      • Gem Menu for Mac OneNote
      • CiteBoard for OneNote
      • Bring to Mac OneNote
      • OneMind for Mac OneNote
      • OneNote Reminder for Mac
      • OneNote Batch for Mac
      • Fix One for Mac - Fix OneNote Login, Sync Tools
    • Android Addins >
      • CiteBoard for OneNote
      • Fix One for Android - Fix OneNote Login, Sync Tools
    • Cross-Platform Addins >
      • OneNote Reminder
      • OneMind for OneNote
      • CiteBoard for OneNote
      • Fix One - Fix OneNote Login, Sync Tools
    • Markdown Addins >
      • Gem for OneNote
      • One Markdown
    • Mind Map Addins >
      • OneNote Gem - Favorites
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • OneMind for OneNote
    • Other Addins >
      • One Markdown
      • Clip to OneNote
      • WordNote
      • OneShare
      • Fix One for Windows - Fix OneNote Login, Sync Tools
  • Buy
  • Documents
  • FAQs
  • Templates
  • Support
  • Release
  • WordNote
Gem Table for OneNote
 
 
The table of merged cells for OneNote

OneNote table insert updatable formula ( Add, Substract, Average, Count, Sum, Max, Min )

2019-11-24 00:18
 
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.
Picture
 
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 )
Picture
 
  • Click the "Table Tools" -> "Gem" tab -> "Formula" command.
Picture
 
  • 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.
 
Picture
 
Show Cells Exists Formula

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

If any cells change in formulas table, we can use "Formula" group -> "Recalculate" command to recalculate exists formulas.
Picture
 
Gem for OneNote v38 improve Table Formula
 
Download Gem for OneNote

Related Documents

  • Formula for OneNote Table Document
  • Copy OneNote Selected Cells, Paste and Replace the Selected Cells in another Table
  • Currency Style for OneNote Cells
  • How to apply Comma Style for OneNote table cells
  • Convert Text to Table in OneNote
Command Line
Tag System
MindMap Add-Ins Comparison
Search Add-Ins Comparison
One Markdown Syntax
Table Formula
Gantt

Gem Menu Templates
Repair OneNote
OneNote Download
English website Chinese website
Mobile Site
Copyright © 2011-2025 Digital GemSoft. OneNoteGem.com All Rights Reserved.