Pabbly Connect supports tons of Spreadsheet functions. Most of the functions supported by Excel or Google Sheets can be used directly inside Pabbly Connect.

Steps to use:

  1. Choose App: Number Formatter
  2. Choose Method: Spreadsheet Formulas
  3. Use the formula you want to use and click on “Save & Send Test Request”
  4. You will find the result in the result key value pair.
  5. You can than map the result in any other module that you need.

Supported Spreadsheet Formulas.

DATE

Function Example call Expected result
DATE
DATE(2008, 7, 8)
 2008-07-08T00:00:00.000Z
DAY
DAY('15-Apr-11')
 15
DAYS
DAYS('3/15/11', '2/1/11')
 42
HOUR
HOUR('7/18/2011 7:45:00 AM')
 7
MINUTE
MINUTE('2/1/2011 12:45:00 PM')
 45
ISOWEEKNUM
ISOWEEKNUM('3/9/2012')
 10
MONTH
MONTH('15-Apr-11')
 4
NOW
NOW()
 2021-05-28T05:33:52.062Z
SECOND
SECOND('2/1/2011 4:48:18 PM')
 18
TIME
TIME(16, 48, 10)
 0.7001157407407408
TIMEVALUE
TIMEVALUE('22-Aug-2011 6:35 AM')
 0.2743055555555556
TODAY
TODAY()
 2021-05-28T05:41:13.217Z
WEEKDAY
WEEKDAY('2/14/2008', 3)
 3
YEAR
YEAR('7/5/2008')
 2008
WEEKNUM
WEEKNUM('3/9/2012', 2)
 11
YEARFRAC
YEARFRAC('1/1/2012', '7/30/2012', 3)
 0.5780821917808219

FINANCIAL

Function Example call Expected result
ACCRINT
ACCRINT('01/01/2011', '02/01/2011', '07/01/2014', 0.1, 1000, 1, 0)
 350
CUMIPMT
CUMIPMT(0.1/12, 30*12, 100000, 13, 24, 0)
 -9916.77251395708
CUMPRINC
CUMPRINC(0.1/12, 30*12, 100000, 13, 24, 0)
 -614.0863271085149
DB
DB(1000000, 100000, 6, 1, 6)
 159500
DDB
DDB(1000000, 100000, 6, 1, 1.5)
 250000
DOLLARDE
DOLLARDE(1.1, 16)
 1.625
DOLLARFR
DOLLARFR(1.625, 16)
 1.1
EFFECT
EFFECT(0.1, 4)
 0.10381289062499977
FV
FV(0.1/12, 10, -100, -1000, 0)
 2124.874409194097
IPMT
IPMT(0.1/12, 6, 2*12, 100000, 1000000, 0)
 928.8235718400465
ISPMT
ISPMT(0.1/12, 6, 2*12, 100000)
 -625
NOMINAL
NOMINAL(0.1, 4)
 0.09645475633778045
NPER
NPER(0.1/12, -100, -1000, 10000, 0)
 63.39385422740764
NPV
NPV(0.1, -10000, 2000, 4000, 8000)
 1031.3503176012546
PDURATION
PDURATION(0.1, 1000, 2000)
 7.272540897341714
PMT
PMT(0.1/12, 2*12, 100000, 1000000, 0)
 -42426.08563793503
PPMT
PPMT(0.1/12, 6, 2*12, 100000, 1000000, 0)
 -43354.909209775076
PV
PV(0.1/12, 2*12, 1000, 10000, 0)
 -29864.950264779152
RATE
RATE(2*12, -1000, -10000, 100000, 0, 0.1)
 0.06517891177181533

ENGINEERING

Function Example call Expected result
BIN2DEC
BIN2DEC(101010)
 42
BIN2HEX
BIN2HEX(101010)
 2a
BIN2OCT
BIN2OCT(101010)
 52
BITAND
BITAND(42, 24)
 8
BITLSHIFT
BITLSHIFT(42, 24)
 704643072
BITOR
BITOR(42, 24)
 58
BITRSHIFT
BITRSHIFT(42, 2)
 10
BITXOR
BITXOR(42, 24)
 50
COMPLEX
COMPLEX(3, 4)
 3+4i
CONVERT
CONVERT(64, 'kibyte', 'bit')
 524288
DEC2BIN
DEC2BIN(42)
 101010
DEC2HEX
DEC2HEX(42)
 2a
DEC2OCT
DEC2OCT(42)
 52
DELTA
DELTA(42, 42)
 1
ERF
ERF(1)
 0.8427007929497149
ERFC
ERFC(1)
 0.1572992070502851
GESTEP
GESTEP(42, 24)
 1
HEX2BIN
HEX2BIN('2a')
 101010
HEX2DEC
HEX2DEC('2a')
 42
HEX2OCT
HEX2OCT('2a')
 52
IMABS
IMABS('3+4i')
 5
IMAGINARY
IMAGINARY('3+4i')
 4
IMARGUMENT
IMARGUMENT('3+4i')
 0.9272952180016122
IMCONJUGATE
IMCONJUGATE('3+4i')
 3-4i
IMCOS
IMCOS('1+i')
 0.8337300251311491-0.9888977057628651i
IMCOSH
IMCOSH('1+i')
 0.8337300251311491+0.9888977057628651i
IMCOT
IMCOT('1+i')
 0.21762156185440265-0.8680141428959249i
IMCSC
IMCSC('1+i')
 0.6215180171704283-0.3039310016284264i
IMCSCH
IMCSCH('1+i')
 0.3039310016284264-0.6215180171704283i
IMDIV
IMDIV('1+2i', '3+4i')
 0.44+0.08i
IMEXP
IMEXP('1+i')
 1.4686939399158851+2.2873552871788423i
IMLN
IMLN('1+i')
 0.3465735902799727+0.7853981633974483i
IMLOG10
IMLOG10('1+i')
 0.1505149978319906+0.3410940884604603i
IMLOG2
IMLOG2('1+i')
 0.5000000000000001+1.1330900354567985i
IMPOWER
IMPOWER('1+i', 2)
 1.2246063538223775e-16+2.0000000000000004i
IMPRODUCT
IMPRODUCT('1+2i', '3+4i', '5+6i')
 -85+20i
IMREAL
IMREAL('3+4i')
 3
IMSEC
IMSEC('1+i')
 0.4983370305551868+0.591083841721045i
IMSECH
IMSECH('1+i')
 0.4983370305551868-0.591083841721045i
IMSIN
IMSIN('1+i')
 1.2984575814159773+0.6349639147847361i
IMSINH
IMSINH('1+i')
 0.6349639147847361+1.2984575814159773i
IMSQRT
IMSQRT('1+i')
 1.0986841134678098+0.45508986056222733i
IMSUB
IMSUB('3+4i', '1+2i')
 2+2i
IMSUM
IMSUM('1+2i', '3+4i', '5+6i')
 9+12i
IMTAN
IMTAN('1+i')
 0.2717525853195117+1.0839233273386946i
OCT2BIN
OCT2BIN('52')
 101010
OCT2DEC
OCT2DEC('52')
 42
OCT2HEX
OCT2HEX('52')
 2a

LOGICAL

Function Example call Expected result
AND
AND(true, false, true)
 false
false
FALSE()
 false
IF
IF('John' = 'John', 'Hello!', 'Goodbye!')
 Hello!
IFS
IFS(false, 'Hello!', true, 'Goodbye!')
 Goodbye!
NOT
NOT(true)
 false
OR
OR(true, false, true)
 true
SWITCH
SWITCH(7, 9, 'Nine', 7, 'Seven')
 Seven
XOR
XOR(true, false, true)
 false

MATH

Function Example call Expected result
ABS
ABS(-4)
 4
ACOS
ACOS(-0.5)
 2.0943951023931957
ACOSH
ACOSH(10)
 2.993222846126381
ACOT
ACOT(2)
 0.46364760900080615
ACOTH
ACOTH(6)
 0.16823611831060645
ARABIC
ARABIC('MCMXII')
 1912
ASIN
ASIN(-0.5)
 -0.5235987755982988
ASINH
ASINH(-2.5)
 -1.6472311463710965
ATAN
ATAN(1)
 0.7853981633974483
ATAN2
ATAN2(-1, -1)
 -2.356194490192345
ATANH
ATANH(-0.1)
 -0.10033534773107562
BASE
BASE(15, 2, 10)
 0000001111
CEILING
CEILING(-5.5, 2, -1)
 -6
CEILINGMATH
CEILINGMATH(-5.5, 2, -1)
 -6
CEILINGPRECISE
CEILINGPRECISE(-4.1, -2)
 -4
COMBIN
COMBIN(8, 2)
 28
COMBINA
COMBINA(4, 3)
 20
COS
COS(1)
 0.5403023058681398
COSH
COSH(1)
 1.5430806348152437
COT
COT(30)
 -0.15611995216165922
COTH
COTH(2)
 1.0373147207275482
CSC
CSC(15)
 1.5377805615408537
CSCH
CSCH(1.5)
 0.46964244059522464
DECIMAL
DECIMAL('FF', 16)
 255
ERF
ERF(1)
 0.8427007929497149
ERFC
ERFC(1)
 0.1572992070502851
EVEN
EVEN(-1)
 -2
EXP
EXP(1)
 2.718281828459045
FACT
FACT(5)
 120
FACTDOUBLE
FACTDOUBLE(7)
 105
FLOOR
FLOOR(-3.1)
 -4
GCD
GCD(24, 36, 48)
 12
INT
INT(-8.9)
 -9
ISEVEN
ISEVEN(-2.5)
 true
ISODD
ISODD(-2.5)
 false
LCM
LCM(24, 36, 48)
 144
LN
LN(86)
 4.454347296253507
LOG
LOG(8, 2)
 3
LOG10
LOG10(100000)
 5
MOD
MOD(3, -2)
 -1
MROUND
MROUND(-10, -3)
 -9
MULTINOMIAL
MULTINOMIAL(2, 3, 4)
 1260
ODD
ODD(-1.5)
 -3
POWER
POWER(5, 2)
 25
PRODUCT
PRODUCT(5, 15, 30)
 2250
QUOTIENT
QUOTIENT(-10, 3)
 -3
RADIANS
RADIANS(180)
 3.141592653589793
RAND
RAND()
 [Random real number greater between 0 and 1]
RANDBETWEEN
RANDBETWEEN(-1, 1)
 [Random integer between bottom and top]
ROUND
ROUND(626.3, -3)
 1000
ROUNDDOWN
ROUNDDOWN(-3.14159, 2)
 -3.14
ROUNDUP
ROUNDUP(-3.14159, 2)
 -3.15
SEC
SEC(45)
 1.9035944074044246
SECH
SECH(45)
 5.725037161098787e-20
SIGN
SIGN(-0.00001)
 -1
SIN
SIN(1)
 0.8414709848078965
SINH
SINH(1)
 1.1752011936438014
SQRT
SQRT(16)
 4
SQRTPI
SQRTPI(2)
 2.5066282746310002
SUM
SUM(-5, 15, 32, 'Hello World!')
 42
SUMSQ
SUMSQ(3, 4)
 25
TAN
TAN(1)
 1.5574077246549023
TANH
TANH(-2)
 -0.9640275800758168
TRUNC
TRUNC(-8.9)
 -8

STATISTICAL

Function Example call Expected result
BETADIST
BETADIST(2, 8, 10, true, 1, 3)
 0.6854705810117458
BETAINV
BETAINV(0.6854705810117458, 8, 10, 1, 3)
 1.9999999999999998
BINOMDIST
BINOMDIST(6, 10, 0.5, false)
 0.205078125
COUNTA
COUNTA([1, null, 3, 'a', '', 'c'])
 4
COUNTUNIQUE
COUNTUNIQUE([1,1,2,2,3,3])
 3
DEVSQ
DEVSQ([2,4,8,16])
 115
EXPONDIST
EXPONDIST(0.2, 10, true)
 0.8646647167633873
FDIST
FDIST(15.2069, 6, 4, false)
 0.0012237917087831735
FINV
FINV(0.01, 6, 4)
 0.10930991412457851
FISHER
FISHER(0.75)
 0.9729550745276566
FISHERINV
FISHERINV(0.9729550745276566)
 0.75
GAMMA
GAMMA(2.5)
 1.3293403919101043
GAMMALN
GAMMALN(10)
 12.801827480081961
GAUSS
GAUSS(2)
 0.4772498680518208
HYPGEOMDIST
HYPGEOMDIST(1, 4, 8, 20, false)
 0.3632610939112487
KURT
KURT([3,4,5,2,3,4,5,6,4,7])
 -0.15179963720841627
LOGNORMDIST
LOGNORMDIST(4, 3.5, 1.2, true)
 0.0390835557068005
LOGNORMINV
LOGNORMINV(0.0390835557068005, 3.5, 1.2, true)
 4.000000000000001
MODESNGL
MODESNGL([1,2,3,4,3,2,1,2,3])
 2
NORMDIST
NORMDIST(42, 40, 1.5, true)
 0.9087887802741321
NORMINV
NORMINV(0.9087887802741321, 40, 1.5)
 42
NORMSDIST
NORMSDIST(1, true)
 0.8413447460685429
PERMUT
PERMUT(100, 3)
 970200
PERMUTATIONA
PERMUTATIONA(4, 3)
 64
PHI
PHI(0.75)
 0.30113743215480443
POISSONDIST
POISSONDIST(2, 5, true)
 0.12465201948308113
SKEW
SKEW([3,4,5,2,3,4,5,6,4,7])
 0.3595430714067974
SKEWP
SKEWP([3,4,5,2,3,4,5,6,4,7])
 0.303193339354144
STANDARDIZE
STANDARDIZE(42, 40, 1.5)
 1.3333333333333333
TDIST
TDIST(60, 1, true)
 0.9946953263673741
TINV
TINV(0.9946953263673741, 1)
 59.99999999996535
WEIBULLDIST
WEIBULLDIST(105, 20, 100, true)
 0.9295813900692769

TEXT

Function Example call Expected result
CHAR
CHAR(65)
 A
CLEAN
CLEAN('Monthly report')
 Monthly report
CODE
CODE('A')
 65
CONCATENATE
CONCATENATE('Andreas', ' ', 'Hauser')
 Andreas Hauser
EXACT
EXACT('Word', 'word')
 false
FIND
FIND('M', 'Miriam McGovern', 3)
 8
LEFT
LEFT('Sale Price', 4)
 Sale
LEN
LEN('Phoenix, AZ')
 11
LOWER
LOWER('E. E. Cummings')
 e. e. cummings
MID
MID('Fluid Flow', 7, 20)
 Flow
PROPER
PROPER('this is a TITLE')
 This Is A Title
REGEXEXTRACT
REGEXEXTRACT('Palo Alto', 'Alto')
 Alto
REGEXMATCH
REGEXMATCH('Palo Alto', 'Alto')
 true
REGEXREPLACE
REGEXREPLACE('Sutoiku', 'utoiku', 'TOIC')
 STOIC
REPLACE
REPLACE('abcdefghijk', 6, 5, '*')
 abcde*k
REPT
REPT('*-', 3)
 *-*-*-
RIGHT
RIGHT('Sale Price', 5)
 Price
ROMAN
ROMAN(499)
 CDXCIX
SEARCH
SEARCH('margin', 'Profit Margin')
 8
SUBSTITUTE
SUBSTITUTE('Quarter 1, 2011', '1', '2', 3)
 Quarter 1, 2012
T
T('Rainfall')
 Rainfall
TRIM
TRIM(' First Quarter Earnings ')
 First Quarter Earnings
UNICHAR
UNICHAR(66)
 B
UNICODE
UNICODE('B')
 66
UPPER
UPPER('total')
 TOTAL

For getting more filtered results check this link:  https://support.google.com/docs/table/25273?hl=en