Supported Spreadsheet Functions
Pebble Stream currently supports these spreadsheet functions. If you do not see a function you need here, don't hesitate to contact Pebble Stream support.
ABS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
AND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
AVERAGE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
BASE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
BITAND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CEILING
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CEILING.MATH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CEILING.PRECISE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CHOOSE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COMBIN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COMBINA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CONCATENATE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTBLANK
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTIF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTIFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DATE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DATEDIF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DAY
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DAYS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DAYS360
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DECIMAL
Microsoft Documentation
ExcelJet documentation
v1.0.0+
EDATE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
EVEN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
EXP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FACT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FACTDOUBLE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FALSE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FLOOR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FLOOR.MATH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FLOOR.PRECISE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
GCD
Microsoft Documentation
ExcelJet documentation
v1.0.0+
HLOOKUP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IFERROR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IFNA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
INDEX
Microsoft Documentation
ExcelJet documentation
v1.0.0+
INT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
INTERCEPT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IPMT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISBLANK
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISERR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISERROR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISEVEN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISLOGICAL
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISNA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISNONTEXT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISNUMBER
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISODD
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISREF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISTEXT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
LEFT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
LOG
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MATCH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MAX
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MID
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MIN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MOD
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MONTH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
N
Microsoft Documentation
ExcelJet documentation
v1.0.0+
NA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
NOT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
NOW
Microsoft Documentation
ExcelJet documentation
v1.0.0+
OFFSET
Microsoft Documentation
ExcelJet documentation
v1.0.0+
OR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
PMT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
POWER
Microsoft Documentation
ExcelJet documentation
v1.0.0+
PPMT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
RAND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
RANDBETWEEN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
RIGHT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ROUND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ROW
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SEARCH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SIGN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SLOPE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SQRT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUM
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMIF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMIFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMPRODUCT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMSQ
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMX2MY2
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMX2PY2
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMXMY2
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SWITCH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
TEXTJOIN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
TRIM
Microsoft Documentation
ExcelJet documentation
v1.0.0+
TRUE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
VLOOKUP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
WEEKDAY
Microsoft Documentation
ExcelJet documentation
v1.0.0+
WORKDAY.INTL
Microsoft Documentation
ExcelJet documentation
v1.0.0+
XOR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
YEAR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
YEARFRAC
Microsoft Documentation
ExcelJet documentation
v1.0.0+
Updated almost 2 years ago