SpreadsheetConverter version 3.4 supports more than 180 of Excel's built-in functions.
SpreadsheetConverter handles mathematical operations, text operations and advanced lookup operations.
Here is the list of functions supported by 3.4. We are continuously adding new functions, if there is a special one you need, let us know.
Arithmetic and operators
- =
- >
- >=
- <
- <=
- <>
- +
- -
- *
- /
- %
- ^
- &
Logical
- IF
- AND
- OR
- NOT
- TRUE
Text
- BIN2DEC
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DOLLAR
- EXACT
- FIND
- FIXED
- HEX2DEC
- LEFT
- LEN
- LOWER
- MID
- OCT2DEC
- PROPER
- REPLACE
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- TEXT
- TRIM
- UPPER
- VALUE
Math and Trig
- ABS
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- CEILING
- COMBIN
- COS
- COSH
- DEGREES
- EVEN
- EXP
- FACT
- FLOOR
- INT
- LN
- LOG
- LOG10
- MOD
- ODD
- PI
- POWER
- PRODUCT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SIGN
- SIN
- SINH
- SQRT
- SUM
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- CORREL
- COUNT
- COUNTA
- COUNTIF
- COVAR
- FORECAST
- HYPGEOMDIST
- LARGE
- MAX
- MAXA
- MIN
- MINA
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PEARSON
- RANK
- RSQ
- SLOPE
- SMALL
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- SUMIF
- VAR
- VARA
- VARP
- VARPA
Information
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISREF
- ISTEXT
- NA
Lookup and Reference
- CHOOSE
- COLUMN
- COLUMNS
- HLOOKUP
- HYPERLINK
- INDEX
- LOOKUP
- MATCH
- ROW
- ROWS
- VLOOKUP
Date and Time
Normal arithmetic with dates is also supported.
- DATE
- DATEDIF
- DATEVALUE
- DAY
- DAYS360
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WORKDAY
- YEAR
Financial
- CUMIPMT
- CUMPRINC
- DB
- DDB
- FV
- IPMT
- IRR
- ISPMT
- MIRR
- NPER
- NPV
- PMT
- PPMT
- PV
- RATE
- SLN
- SYD
Analysis Toolpak
- NETWORKDAYS
- QUOTIENT