Spreadsheets

Differences Lite/PRO   

AM-Notebook supports spreadsheets with simple formulas. A spreadsheet is a grid that organizes data into columns and rows. Each spreadsheet has a header where you can enter a description and the cells where you can enter strings, numbers and formulas.

Strings are automatically left aligned, numbers are automatically right aligned.

Each cell can have a simple formula which must start with the equal character "=".


Functions and Formulas:

Operators in formulas:

+Addition
-Subtraction
*Multiplication
/Division
^Exponential (only positive numbers)
(Open parenthesis
)Close parenthesis
MODMOD operator


Functions in formulas:

SUM(StartCell:EndCell)sum of all cell values in range, for example SUM(A5:B10)
AVG(StartCell:EndCell)average of all cell values in range, for example SUM(B3:B10)
ABS(parameter)absolute value
EXP(parameter)exponential of value
ROUND(parameter)rounds value
SQRT(parameter)square root of value
SQR(parameter)square of value
TRUNC(parameter)truncates value


The cells in formulas are updated when you insert/delete rows and columns (for example, =B5+C5 will become =B6+C6 when you enter a line before row number 5).

Please note that cells in formulas are not updated when you move columns or rows via Drag&Drop!


Cell Ranges:

Cell ranges are identified by the top-left cell and the bottom-right cell, splitted by a':' and can be used in several functions (see table above), for example the SUM function.

Example:
=SUM(A5:B7)
A5:B7 specifies the range of cells from cell A5 to cell B7, exactly the cells A5+A6+A7+B5+B6+B7.




Examples and Screenshots: