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 |