Supported Excel Functions
SpreadsheetConverter converts Excel spreadsheets to web pages, with support for more than 180 of Excel's built-in functions.
SpreadsheetConverter can convert Excel functions for mathematical operations, text operations and advanced lookup operations.
If you are concerned that your spreadsheet may not be fully supported by SpreadsheetConverter, just send it to us and we'll convert it to a webpage for you, for free.
Here is the list of functions supported in version 3.4. We are continuously adding new functions, if there is a special one you need, please 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


