The following Excel-compatible functions can be used in JCVGantt user spreadsheets.
(Note: we will be more fully documenting these features in a later release, for the moment, here is a list of features which may be referenced against this list of instructions on how to use them:
http://www.techonthenet.com/excel/formulas/index.htm)
|
ABS |
|
ACOS |
|
ACOSH |
|
ADD |
|
AND |
|
ASIN |
|
ASINH |
|
ATAN |
|
ATAN2 |
|
ATANH |
|
AVERAGE |
|
CEILING |
|
CHAR |
|
CLEAN |
|
CODE |
|
COMBIN |
|
CONCATENATE |
|
COS |
|
COSH |
|
DATE |
|
DAY |
|
DB |
|
DDB |
|
DEGREES |
|
EVEN |
|
EXACT |
|
EXP |
|
FACT |
|
FIND |
|
FLOOR |
|
FV |
|
HOUR |
|
IF |
|
INT |
|
INVERSE |
|
ISBLANK |
|
ISEVEN |
|
ISNONTEXT |
|
ISNUMBER |
|
ISODD |
|
ISREF |
|
ISTEXT |
|
LEFT |
|
LEN |
|
LN |
|
LOG |
|
LOG10 |
|
LOWER |
|
MAX |
|
MEDIAN |
|
MID |
|
MIN |
|
MINUTE |
|
MOD |
|
MODE |
|
MONTH |
|
NEG |
|
NOT |
|
NOW |
|
NPER |
|
ODD |
|
OR |
|
PERMUT |
|
PI |
|
PMT |
|
POWER |
|
PRODUCT |
|
PROPER |
|
PV |
|
RADIANS |
|
RAND |
|
RANK |
|
REPLACE |
|
REPT |
|
RIGHT |
|
ROUND |
|
ROUNDDOWN |
|
ROUNDUP |
|
SECOND |
|
SIGN |
|
SIN |
|
SINH |
|
SLN |
|
SQRT |
|
SQUARE |
|
STDEV |
|
STDEVP |
|
SUBSTITUTE |
|
SU |
|
SUMSQ |
|
SYD |
|
TAN |
|
TANH |
|
TIME |
|
TODAY |
|
TRIM |
|
TRUNC |
|
UPPER |
|
URL |
|
VAR |
|
VARP |
|
WEEKDAY |
|
XROOT |
|
YEAR |
|
|
|
|
|
|