The WebCalcManager provides the following functions to your application:
| Mathematical
|
Financial
|
Text & Data
|
Date/Time |
Information |
Statistical
|
| SUM |
PV |
UPPER |
DATE |
NA |
COUNT |
| AVG |
FV |
LOWER |
DATEVALUE |
TYPE |
MIN |
| MOD |
NPV |
CONCATENATE |
TODAY |
ERRORTYPE |
MAX |
| ROUND |
IRR |
LEFT |
DAY |
ISBLANK |
STD |
| TRUNCATE |
NPER |
LEN |
MONTH |
ISERROR |
MEDIAN |
| EVEN / ODD |
PMT |
MID |
YEAR |
ISNA |
VAR |
| ABSOLUTE |
PPMT |
HOUR |
ISNUMBER |
|
|
| CEILING |
IPMT |
TRIM |
MINUTE |
ISTEXT |
|
| FLOOR |
RATE |
VALUE |
SECOND |
ISEVEN |
|
| INT |
INTRATE |
FIND |
NOW |
ISODD |
|
| LOG |
DB |
REPLACE |
TIME |
|
|
| LN |
DDB |
CHAR |
TIMEVALUE |
|
|
| LOG10 |
SLN |
CODE |
DAYS360 |
|
|
| RAND |
SYD |
ASC |
|
|
|
| PI |
|
FIXED |
|
|
|
| EXP |
|
|
|
|
|
| POWER |
|
|
|
|
|
| PRODUCT |
|
|
|
|
|
| QUOTIENT |
|
|
|
|
|
| ACOS |
|
|
|
|
|
| ATAN |
|
|
|
|
|
| ATAN2 |
|
|
|
|
|
| ATANH |
|
|
|
|
|
| COS |
|
|
|
|
|
| COSH |
|
|
|
|
|
| TAN |
|
|
|
|
|
| TANH |
|
|
|
|
|
| SQRT |
|
|
|
|
|