Back to Vonixx Web Site

HOME

License Agreement

Date & Time Functions
CHINESEDATE
CHINESEDATEPRO
DATE2NUMBER
DAYNAME
DAYOFYEAR
DAYSINMONTH
DAYSLEFTINYEAR
ISHOLIDAY
ISLEAPYEAR
MONTHNAME
MONTHWEEK
MOONPHASE
SUNRISE
SUNSET
SUNTIMES
TEXTDATE
UTCOFFSET
WEEKDAYCOUNT
ZODIAC

Financial Functions
BENFORD
FD
F2D
F3D
MATURITY

Range/Reference Functions
FIND_COLUMN_INDEX
FIND_ROW_INDEX
XLOOKUP

Math & Trigonometric Functions
ACOSEC
ACOTAN
ASEC
COSEC
COTAN
HACOSEC
HACOTAN
HASEC
HCOS
HCOTAN
HSIN
HTAN
ISEVEN
ISODD
ISPRIME
LOGN
ORDINAL
PRODUCT3D
PRODUCTROUND
PRODUCTROUND3D
ROUNDSIG
SEC
STATICRAND
SUM3D
SUMROUND
SUMROUND3D

Statistical Functions
AVERAGE3D
AVERAGEROUND
COUNT3D
COUNTA3D
COUNTBLANK3D
EVENCOUNTBETWEEN
INTCOUNTBETWEEN
LARGE3D
MAX3D
MIN3D
ODDCOUNTBETWEEN
SMALL3D

Text Functions
CONTAINS
INSERTSTRING
NUM2CHINESE
NUM2TXT
REMOVEIRRSPACE
REMOVESPACE
SCRAMBLE
UNIQUECHAR
UNIQUECHARCOUNT

Scientific Functions
ABSZERO
ATOMIC
AVOGADRO
BOHRMAG
BOLTZ (BOLTZMANN)
ELCHARGE
ELEMENT
EMASS
FARADAY
FINESTRCONST
GCONST
GRAVITY
LIGHT
NEUTRON
NMASS
NUCLEARMAG
PLANCK
PMASS
SOUND
SOUNDA
SOUNDW
VACUUMP

Information Functions
APPBUILD
APPVERSION
CELLCOLORINDEX
CELLCOMMENT
CELLFORMULA
CELLNUMBERFORMAT
CONTAINFORMULA
DEFAULTPRINTER
EXCELDIR
FILEEXIST
FONTINSTALLED
FULLPATH
ISLOCALNAME
OS
SHAPEHEIGHT
SHAPEWIDTH
SHEETNAME
STDFONT
STDFONTSIZE
USER
WINHEIGHT
WINMAXHEIGHT
WINMAXWIDTH
WINWIDTH
WORKSHEETCOUNT

Miscellaneous Functions
ARRAYDIMENSION (for VBA)
CREDITCARDTYPE
SOUNDEX
VALIDCREDITCARD