Spreadsheets

Top  Previous  Next

AM-Notebook supports Microsoft Excel® style spreadsheets with formulas. Each spreadsheet has a header where you can enter a description and the cells where you can enter strings, numbers and formulas.

Moving rows/columns

Whole rows and columns can be moved via Drag-and-Drop. Cell references in formulas are automatically updated when you move rows or columns.

Sorting

Spreadsheets can be sorted via a header double click.

Calculating SUM, etc.

The functions SUM, AVERAGE, COUNT, MAX and MIN can be inserted via the context menu. Select multiple cells in a single line or a single row, then call one of these functions in the context menu. AM-Notebook will insert the formula into the first field next to the selection.

Excel® compatible formulas

Cell references, arithmetic operations, and syntax rules in formulae are identical to Microsoft Excel® ones. The supported functions are identical to Microsoft Excel® functions. You may use the Microsoft Excel® help system as a reference on formulae and functions.

 

Currently supported spreadsheet functions

 

ABS

ACOS

ACOSH

AND

ASIN

ASINH

ATAN

ATAN2

ATANH

AVERAGE

CEILING

CHAR

CHOOSE

CLEAN

CODE

COMBIN

CONCATENATE

CORREL

COS

COSH

COUNT

COUNTA

COUNTBLANK

COUNTIF

COVAR

DATE

DATEDIF

DATEVALUE

DAY

DEGREES

DOLLAR

EDATE

EOMONTH

EVEN

EXACT

EXP

FACT

FACTDOUBLE

FALSE

FIND

FIXED

FLOOR

GCD

HOUR

IF

INT

INTERCEPT

ISBLANK

ISERR

ISERROR

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISTEXT

LARGE

LCM

LEFT

LEN

LN

LOG

LOG10

LOOKUP

LOWER

MAX

MEDIAN

MID

MIN

MINUTE

MOD

MONTH

MROUND

MULTINOMIAL

N

NA

NOT

NOW

ODD

OR

PI

POWER

PRODUCT

PROPER

QUOTIENT

RADIANS

RAND

RANDBETWEEN

REPLACE

REPT

RIGHT

ROUND

ROUNDDOWN

ROUNDUP

SECOND

SIGN

SIN

SINH

SLOPE

SMALL

SQRT

SQRTPI

STDEV

STDEVP

SUBSTITUTE

SUM

SUMIF

SUMSQ

T

TAN

TANH

TEXT

TIME

TIMEVALUE

TODAY

TRIM

TRUE

TRUNC

UPPER

VALUE

VAR

VARP

WEEKDAY

YEAR

YEN