Skip to main content

Execute Excel Formula

Overview​

The Execute Excel Formula service allows you to run Excel formulas directly over Marketo fields via a webhook. RDN provides 254 built-in Excel formulas through this service.

Execute Excel Formula Service

You can view live examples of each formula by clicking API Details in the service.

API Details Example

Example Usage​

To add a Behavioral Score and a Demographic Score in Marketo, use the following webhook URL:

https://api.rightwave.com/rdn/api/adv/excelFormula?fm=SUM(lead.Behavior Score,lead.Demographic Score)

The webhook returns the result as JSON, which can be mapped to the Lead Score field:

{"output": <Sum of Behavior Score and Demographic Score>}
tip

If Behavior Score = 10.1 and Demographic Score = 10, the result will be {"output": 20.1}.

Configuring in Marketo​

Service Name: Execute Excel Formula
Service Type: Advanced Service

info

The request parameter values and Marketo Fields shown are examples. Enter values based on your specific service requirement.

Step 1 — Create a New Webhook​

Go to Admin → Webhooks and click New Webhook.

Step 2 — Configure the Webhook​

FieldValue
Webhook NameExecute Excel Formula (or as per requirement)
URLhttps://api.rightwave.com/rdn/api/adv/excelFormula?fm=SUM(lead.Behavior Score,lead.Demographic Score)
TemplateLeave blank
Request Token EncodingNone (POST) / uneditable (GET)
Response TypeJSON
Request TypeGET

Step 3 — Add Authentication Header​

Authentication Header
caution

Use the exact same auth-key and Content-Type values when configuring the webhook.

Step 4 — Response Mappings​

Map the output response attribute to the appropriate Marketo field. Returning JSON is recommended for easy field mapping.

Supported Excel Formulas​

RDN supports 254 Excel formulas. The table below lists all available formulas with URL examples and expected outputs.

SN.FormulaDescriptionURL ExampleOutput Example
1SUMSUM function adds the numerical values.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SUM(-10.1,-10){"output":-20.1}
2ABSABS function returns the absolute value of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ABS(-90){"output":90}
3ACCRINTACCRINT function returns the accrued interest for a security that pays periodic interest.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACCRINT("1/1/2010", "2/1/2010", "12/31/2012", 0.025, 100, 4, 0){"output":7.5}
4ACOSACOS function returns the inverse cosine of a value in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOS(1){"output":0}
5ACOSHACOSH function returns the inverse hyperbolic cosine of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOSH(10){"output":2.993222846126381}
6ACOTACOT function returns the inverse cotangent of a value in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOT(-1){"output":-0.7853981633974483}
7ACOTHACOTH function returns the inverse hyperbolic cotangent of a value in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOTH(2){"output":0.5493061443340548}
8ADDADD function returns the sum of two numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ADD(-1,-1){"output":-2}
9ANDAND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.https://api.rw001.com/rdn/api/adv/excelFormula?fm=AND(10>5,10>100){"output":false}
10ARABICARABIC function converts roman numbers to arabic numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ARABIC("XIV"){"output":14}
11ASINASIN function returns the inverse sine of a value in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ASIN(1){"output":1.5707963267948966}
12ASINHASINH function returns the inverse hyperbolic sine of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ASINH(10){"output":2.99822295029797}
13ATANATAN function returns the inverse tangent of a value in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ATAN(1){"output":0.7853981633974483}
14ATAN2ATAN2 function calculates the inverse tangent of a given set of x and y coordinates, and returns an angle, in radians, between -π/2 and +π/2.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ATAN2(1,1){"output":0.7853981633974483}
15ATANHATANH function returns the inverse hyperbolic tangent of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ATANH(-0.5){"output":-0.5493061443340549}
16AVEDEVAVEDEV function calculates the average of absolute deviations from the mean in a given set of data.https://api.rw001.com/rdn/api/adv/excelFormula?fm=AVEDEV(50,47,52,46,45,48){"output":2}
17AVERAGEAVERAGE function returns the numerical average of value in a dataset, ignore logical values and numbers entered as text.https://api.rw001.com/rdn/api/adv/excelFormula?fm=AVERAGE(5,7,-5,1){"output":2}
18AVERAGEAAVERAGEA function returns the average of value in a dataset. AVERAGEA calculates the logical values TRUE and FALSE, and numbers represented as text.https://api.rw001.com/rdn/api/adv/excelFormula?fm=AVERAGEA(5,5,TRUE,TRUE){"output":3}
19BASEBASE function converts a number into a text representation in another base, for example, base 2 for binary.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BASE(5,2,8){"output":"00000101"}
20BESSELIBESSELI function returns the modified Bessel function.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BESSELI(1,1){"output":0.5651590975819435}
21BESSELJBESSELJ function returns the Bessel function Jn(x), for a specified order and value of x.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BESSELJ(1.9,2){"output":0.3299258286697852}
22BESSELKBESSELK function returns the modified Bessel function Kn(x), which is equivalent to the Bessel functions evaluated for purely imaginary arguments, for a specified order and value of x.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BESSELK(1.5, 1){"output":0.2773878036322587}
23BESSELYBESSELY function returns the Bessel function Yn(x),also known as the Weber function or the Neumann function, for a specified order and value of x.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BESSELY(2.5, 1){"output":0.14591813750831284}
24BETA.DISTBeta.Dist function calculates the cumulative beta distribution function or the probability density function of the Beta distribution, for a set of parameters.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BETA.DIST(3, 7.5, 9, TRUE, 1, 4){"output":0.9603709374928316}
25BETA.INVBETA.INV function calculates the inverse of the cumulative beta distribution function or the probability density function of the Beta distribution, for a set of parameters.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BETA.INV(0.3, 7.5, 9, 1, 4){"output":2.164759761010195}
26BETAINVBETAINV function calculates the inverse of the cumulative beta probability density function for a supplied probability.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BETAINV(0.65, 1.234, 7, 1, 3){"output":1.3408840513535847}
27BETADISTBETADIST function calculates the cumulative beta probability density function for a supplied set of parameters.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BETADIST(2,8,10,1,3){"output":0.6854705810117458}
28BIN2DECBIN2DEC function converts a binary number to the decimal equivalent. The input number must contain only zeros and ones and does not contain more than 10 characters ( 10 bits ).https://api.rw001.com/rdn/api/adv/excelFormula?fm=BIN2DEC(1000){"output":8}
29BIN2HEXBIN2HEX function converts a binary number to hexadecimal.The input number must contain only zeros and ones and does not contain more than 10 characters ( 10 bits ).https://api.rw001.com/rdn/api/adv/excelFormula?fm=BIN2HEX(1111){"output":"f"}
30BIN2OCTBIN2OCT function converts a binary number to octal.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BIN2OCT(10011){"output":"23"}
31BINOM.DISTBINOM.DIST function returns the individual term binomial distribution probability. BINOM.DIST returns probability as a decimal number between 0 and 1.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BINOM.DIST(6,10,0.5,FALSE){"output":0.205078125}
32BINOM.DIST.RANGEBINOM.DIST.RANGE function returns the binomial distribution probability for the number of successes within a specified range from a specified number of trials.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BINOM.DIST.RANGE( 100, 0.5, 0, 40 ){"output":0.028443966820490378}
33BINOM.INVBINOM.INV function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BINOM.INV( 100, 0.5, 0.2 ){"output":46}
34BINOMDISTBINOMDIST function returns the individual term binomial distribution probability.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BINOMDIST(6,10,0.5,FALSE){"output":0.205078125}
35BITANDBITAND function returns a decimal number representing the bitwise AND of two numbers. The function performs a logical AND operation on each corresponding bit in the binary representation of the two numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BITAND(13,25){"output":9}
36BITLSHIFTBITLSHIFT function shifts the bits of the input a certain number of places to the left. Shifting a number left is equivalent to adding zeros (0) to the right of the binary representation of the number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BITLSHIFT(4,2){"output":16}
37BITORBITOR function returns a decimal number representing the bitwise OR of two numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BITOR(6,4){"output":6}
38BITRSHIFTBITRSHIFT function returns a number shifted right by the specified number of bits. Shifting a number right is equivalent to removing digits from the rightmost side of the binary representation of the number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BITRSHIFT(13,2){"output":3}
39BITXORBITXOR function returns a decimal number representing the bitwise XOR of two numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=BITXOR(5,3){"output":6}
40CEILINGCEILING function rounds a number up to a given multiple. If the number is already an exact multiple, no rounding occurs and the original number is returned.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CEILING(5.37,5){"output":10}
41CHARCHAR function returns a character when given a valid character code.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHAR(65){"output":"A"}
42CHISQ.DISTCHISQ.DIST function calculates the Probability Density Function or the Cumulative Distribution Function for the Chi-Square Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHISQ.DIST(0.5,1,TRUE){"output":0.5204998778130242}
43CHISQ.DIST.RTCHISQ.DIST.RT function calculates the right-tailed probability of the Chi-Square Distributionhttps://api.rw001.com/rdn/api/adv/excelFormula?fm=CHISQ.DIST.RT(18.307,10){"output":0.05000058909139815}
44CHISQ.INVCHISQ.INV function calculates the inverse of the left-tailed probability of the Chi-Square Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHISQ.INV(0.6,2){"output":1.8325814637483095}
45CHISQ.INV.RTCHISQ.INV.RT returns the inverse of the right-tailed probability of the chi-squared distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHISQ.INV.RT(0.07,10){"output":17.202573968604092}
46CHOOSECHOOSE function returns a value from a list using a given position or index.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHOOSE(1,"Wide",115,"world",8){"output":"Wide"}
47CODECODE function returns a numeric code for the first character in a text string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CODE("a"){"output":97}
48COMBINCOMBIN function returns the number of combinations(without repetitions) for a given number of items.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COMBIN(8,3){"output":56}
49COMBINAReturns the number of combinations (with repetitions) for a given number of items.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COMBINA(10,3){"output":220}
50COMPLEXCOMPLEX function creates a complex number with given real and imaginary coefficients.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COMPLEX(3,4,"j"){"output":"3+4j"}
51CONCATENATECONCATENATE function concatenates up to 30 values together and returns the result as text.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CONCATENATE("Black"," and ","Blue"){"output":"Black and Blue"}
52CONFIDENCECONFIDENCE function returns the confidence interval for a population mean, using a normal distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CONFIDENCE(0.05,2.5,50){"output":0.6929519121748391}
53CONFIDENCE.NORMCONFIDENCE.NORM returns the confidence interval for a population mean, using a normal distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CONFIDENCE.NORM(0.05,2.5,50){"output":0.6929519121748391}
54CONFIDENCE.TCONFIDENCE.T returns the confidence interval for a population mean, using a Student's t distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CONFIDENCE.T(0.05,1,50){"output":0.28419685015290463}
55CONVERTCONVERT function converts a number in one measurement system to another.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CONVERT(1,"mn","sec"){"output":60}
56COSCOS function returns the cosine of an angle provided in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COS(0){"output":1}
57COSHCOSH function returns the hyperbolic cosine of any real number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COSH(4){"output":27.308232836016487}
58COTCOT function returns the cotangent of an angle provided in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COT(45){"output":0.6173696237835551}
59COTHCOTH function returns the hyperbolic cotangent of any real number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COTH(2){"output":1.0373147207275482}
60COUNTCOUNT function returns a count of values that are numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COUNT(1,2,3,4,"red",TRUE){"output":4}
61COUNTACOUNTA function counts the number of cells that are not empty in a range.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COUNTA(1,2,3,4,"red",TRUE){"output":6}
62COUNTBLANKCOUNTBLANK function returns a count of empty cells in a range.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COUNTBLANK("","",""){"output":3}
63COUNTUNIQUECOUNTUNIQUE function counts the number of unique values in a list of specified values and ranges.https://api.rw001.com/rdn/api/adv/excelFormula?fm=COUNTUNIQUE(1,2,1,2){"output":2}
64CSCCSC function returns the cosecant of an angle provided in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CSC(15){"output":1.5377805615408537}
65CSCHCSCH function returns the hyperbolic cosecant of any real number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CSCH(1.5){"output":0.46964244059522464}
66CUMIPMTCUMIPMT function returns the cumulative interest paid on a loan between a start period and an end period.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CUMIPMT(0.09/12,30*12,125000,1,1,0){"output":-937.5}
67CUMPRINCCUMPRINC function returns the cumulative principal paid on a loan between a start period and an end period.https://api.rw001.com/rdn/api/adv/excelFormula?fm=CUMPRINC(0.09/12,30*12,125000,1,1,0){"output":-68.27827118097684}
68DATEVALUEDATEVALUE function converts a date that is stored as text to a serial number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DATEVALUE("8/22/2011"){"output":40777}
69DAYDAY function returns the day of the month as a number between 1 to 31 from a given date.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DAY(DATE(2019,5,31)){"output":31}
70DAYSDAYS function returns the number of days between two dates.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DAYS("15-MAR-2021","1-MAR-2021"){"output":14}
71DBDB function returns the depreciation of an asset for a specified period using the fixed-declining balance method.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DB(10000, 5000, 5, 1,12){"output":1290}
72DDBDDB function calculates the depreciation of an asset for a specified period using the double-declining balance method.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DDB(2400,300,10,1,2){"output":480}
73DEC2BINDEC2BIN function converts a decimal number to its binary equivalent.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEC2BIN(9, 4){"output":"1001"}
74DEC2HEXDEC2HEX function converts a decimal number to its hexadecimal equivalent.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEC2HEX(100, 4){"output":"0064"}
75DEC2OCTDEC2OCT function converts a decimal number to its octal equivalent.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEC2OCT(58, 3){"output":"072"}
76DECIMALDECIMAL function converts the text representation of a number to base 10 (decimal).https://api.rw001.com/rdn/api/adv/excelFormula?fm=DECIMAL("1101",2){"output":13}
77DEGREESDEGREES function converts an angle value in radians to degrees.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEGREES(0.7854){"output":45.00010522957485}
78DELTADELTA function will test if two numeric values are equal. When values are equal, DELTA returns 1, otherwise, DELTA returns zero.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DELTA(5,5){"output":1}
79DEVSQDEVSQ function calculates the sum of the squared deviations from the mean for a given set of data.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEVSQ(50,47,52,46,45,48){"output":34}
80DIVIDEDIVIDE function returns one number divided by another.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DIVIDE(20,3){"output":6.666666666666667}
81DOLLARDEDOLLARDE function converts a price quotation given as a decimal fraction into a decimal value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DOLLARDE(1.02,16){"output":1.125}
82DOLLARFRDOLLARFR function converts a price quotation given as a decimal value into a decimal fraction.https://api.rw001.com/rdn/api/adv/excelFormula?fm=DOLLARFR(1.125,16){"output":1.02}
83EFFECTEFFECT function returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EFFECT(0.0525,4){"output":0.05354266737075819}
84EOMONTHEOMONTH function calculates the last day of the month after adding a specified number of months to a date. The result is returned as a serial date.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EOMONTH("3/1/2012",3){"output":41090}
85EQEQ function returns "TRUE" if two specified values are equal and "FALSE" otherwise.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EQ(16, -16){"output":false}
86ERFERF function returns the error function integrated between lower_limit and upper_limit.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ERF(1){"output":0.8427007929497149}
87ERFCERFC returns the complementary ERF function integrated between lower_limit and infinity.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ERFC(1){"output":0.1572992070502851}
88EVENEVEN function returns number rounded up to the nearest even integer.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EVEN(1.5){"output":2}
89EXACTEXACT function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EXACT("word","w ord"){"output":false}
90EXPEXP function returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EXP(1){"output":2.718281828459045}
91EXPON.DISTEXPON.DIST function returns the value of the exponential distribution function with a specified lambda at a specified value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EXPON.DIST(0.2,10,TRUE){"output":0.8646647167633873}
92EXPONDISTEXPONDIST function returns the value of the exponential distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=EXPONDIST(0.2,10,TRUE){"output":0.8646647167633873}
93F.DISTF.DIST function calculates the Probability Density Function or the Cumulative Distribution Function for the F Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=F.DIST(15.2069,6,4,TRUE){"output":0.9900000430027627}
94F.DIST.RTF.DIST.RT function calculates the right-tailed F probability distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=F.DIST.RT(15.2068649,6,4){"output":0.009999999952464589}
95F.INVF.INV function calculates the inverse of the left-tailed F probability distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=F.INV(0.01,6,4){"output":0.10930991412457851}
96F.INV.RTF.INV.RT function calculates the inverse of the right-tailed F probability distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=F.INV.RT(0.01,6,4){"output":15.206864861157555}
97FACTFACT function returns the factorial of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FACT(5.5){"output":120}
98FACTDOUBLEFACTDOUBLE function returns the double factorial of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FACTDOUBLE(8){"output":384}
99FDISTFDIST function returns the (right-tailed) F probability distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FDIST(15.207,6,4){"output":0.0012237692561725372}
100FINDFIND function returns the position at which a string is first found within text, case-sensitive.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FIND("t","testcase"){"output":1}
101FINVFINV function returns the inverse of the (right-tailed) F probability distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FINV(0.01,6,4){"output":0.10930991412457851}
102FISHERFISHER function returns the Fisher transformation of a specified value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FISHER(0.75){"output":0.9729550745276566}
103FISHERINVFISHERINV function returns the inverse Fisher transformation of a specified value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FISHERINV(0.972955){"output":0.7499999673941484}
104FLOORFLOOR function rounds a number down to the nearest integer multiple of specified significance.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FLOOR(5.4,2){"output":4}
105FVFV function calculates the future value of an investment based on constant-amount periodic payments and a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=FV(0.12/12, 12,-1000){"output":12682.503013196976}
106GAMMAGAMMA function returns the Gamma function evaluated at the specified value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMA(2.5){"output":1.3293403919101043}
107GAMMA.DISTGamma.Dist function calculates the value of either the cumulative distribution or the probability density function for the Gamma Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMA.DIST(10,9,2,FALSE){"output":0.03263901967407176}
108GAMMA.INVGAMMA.INV function returns the inverse of the Gamma Cumulative Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMA.INV(0.068094,9,2){"output":10.00001119143767}
109GAMMADISTGAMMADIST function returns the Gamma Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMADIST(10,9,2,FALSE){"output":0.03263901967407176}
110GAMMAINVGAMMAINV function returns the inverse of the Gamma Cumulative Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMAINV(0.068094,9,2){"output":10.00001119143767}
111GAMMALNGAMMALN function returns the natural logarithm of the gamma function.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMALN(4){"output":1.791759469228055}
112GAMMALN.PRECISEGAMMALN.PRECISE function returns the natural logarithm of the gamma function.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMALN.PRECISE(4){"output":1.791759469228055}
113GAUSSGAUSS function calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAUSS(2){"output":0.4772498680518208}
114GCDGCD function returns the greatest common divisor of two or more integers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GCD(24, 36){"output":12}
115GEOMEANGEOMEAN function returns the geometric mean for a set of numeric values.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GEOMEAN(4,5,7,8,11,4,3){"output":5.476986969656962}
116GESTEPGESTEP function check whether the given number is greater than the given threshold value(given step value).https://api.rw001.com/rdn/api/adv/excelFormula?fm=GESTEP(-4, -5){"output":1}
117GTEGTE function check whether the first value is greater than or equal to the second value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=GTE(8, 10){"output":false}
118HARMEANHARMEAN function returns the harmonic mean for a set of numeric values.https://api.rw001.com/rdn/api/adv/excelFormula?fm=HARMEAN(4,5,8,7,11,4,3){"output":5.028375962061728}
119HEX2BINHEX2BIN function converts a hexadecimal number to its binary equivalent.https://api.rw001.com/rdn/api/adv/excelFormula?fm=HEX2BIN("F", 8){"output":"00001111"}
120HEX2DECHEX2DEC function converts a hexadecimal number to its decimal equivalent.https://api.rw001.com/rdn/api/adv/excelFormula?fm=HEX2DEC("A5"){"output":165}
121HEX2OCTHEX2OCT function converts a hexadecimal number to its octal equivalent.https://api.rw001.com/rdn/api/adv/excelFormula?fm=HEX2OCT("F", 3){"output":"017"}
122HYPGEOM.DISTHYPGEOM.DIST function returns the value of the hypergeometric distribution for a specified number of successes from a population sample.https://api.rw001.com/rdn/api/adv/excelFormula?fm=HYPGEOM.DIST(1,4,8,20,TRUE){"output":5.028375962061728}
123HYPGEOMDISTHYPGEOMDIST function returns the hypergeometric distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=HYPGEOMDIST(1,4,8,20){"output":0.3632610939112487}
124IFIF function returns one value for a TRUE result, and another for a FALSE result.https://api.rw001.com/rdn/api/adv/excelFormula?fm=IF(20>=40,"YES","NO"){"output":"NO"}
125INTINT function returns the integer part of a decimal number by rounding down to the integer.https://api.rw001.com/rdn/api/adv/excelFormula?fm=INT(8.9){"output":8}
126IPMTIPMT function calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=IPMT(0.1/12, 1, 3*12, 8000){"output":-66.66666666666667}
127ISEVENISEVEN function returns TRUE when a value is an even number, and FALSE when a value is an odd number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISEVEN(2.5){"output":true}
128ISLOGICALISLOGICAL function checks whether a value is TRUE or FALSE.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISLOGICAL(TRUE){"output":true}
129ISNONTEXTISNONTEXT function returns FALSE if the value is TEXT and it returns TRUE if not.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISNONTEXT(100){"output":true}
130ISNUMBERISNUMBER function returns TRUE when a value is number, and FALSE if not.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISNUMBER(9/17/2011){"output":true}
131ISODDISODD function returns TRUE when a value is an odd number, and FALSE when a value is an even number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISODD(3.14){"output":true}
132ISOWEEKNUMISOWEEKNUM function returns the ISO week number from a date value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISOWEEKNUM("1/9/2012"){"output":2}
133ISPMTISPMT function calculates the interest paid during a given period of an investment where principal payments are equal.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISPMT( 0.05/12, 1, 60, 50000 ){"output":-204.86111111111111}
134ISTEXTISTEXT function returns TRUE when a value is text, and FALSE if not.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISTEXT(9/17/2021){"output":false}
135KURTKURT function calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.https://api.rw001.com/rdn/api/adv/excelFormula?fm=KURT(3,5,6,8){"output":0.39053254437870244}
136LCMLCM function returns the least common multiple of integers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LCM(10,100){"output":100}
137LEFTLEFT function extracts a given number of characters from the left side of a text string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LEFT("TestCase",4){"output":"Test"}
138LENLEN function returns the length of a given text string. LEN will also count characters in numbers, but number formatting is not included.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LEN("Advance excel formula"){"output":21}
139LNLN function returns the natural logarithm of a given number. The natural logarithm is equivalent to log base e of a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LN(86){"output":4.454347296253507}
140LOGLOG function returns the the logarithm of a number, using a supplied base.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LOG(86, 2.7182818){"output":4.454347342888287}
141LOG10LOG10 function returns the logarithm of a number, base 10.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LOG10(86){"output":1.9344984512435675}
142LOGNORM.INVLOGNORM.INV function returns the x value for the probability of lognormal distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LOGNORM.INV(0.345, 2.5, 1.1){"output":7.855857467852377}
143LOWERLOWER function converts a text string to all lowercase letters.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LOWER("Test CASE"){"output":"test case"}
144LTLT function returns TRUE if the first argument is strictly less than the second and FALSE otherwise.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LT(10,4){"output":false}
145LTELTE function returns TRUE if the first argument is less than or equal to the second and FALSE otherwise.https://api.rw001.com/rdn/api/adv/excelFormula?fm=LTE(10,10){"output":true}
146MAXMAX function returns the largest numeric value in a range of values.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MAX(100,90,121,234){"output":234}
147MAXAMAXA function returns the largest numeric value in a range of values. The MAXA function also evaluates the logical values TRUE and FALSE as 1 and 0.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MAXA(-1,-2,-3,-5,TRUE){"output":1}
148MEDIANMEDIAN function returns the median in a group of supplied numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MEDIAN(1,2,3,4,5,6){"output":3.5}
149MIDMID function returns a segment of a string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MID("test case",7,20){"output":"ase"}
150MINMIN function returns the smallest numeric value in a range of values.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MIN(1,2,4,7,FALSE){"output":1}
151MINAMINA function returns the smallest numeric value in a range of values. The MINA function also evaluates the logical values TRUE and FALSE as 1 and 0.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MINA(1,2,4,7,FALSE){"output":0}
152MINUSMINUS function returns the difference of two numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MINUS(-11,-12){"output":1}
153MODMOD function returns the remainder of two numbers after division.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MOD(10,-3){"output":-1}
154MODE.MULTMODE.MULT function returns an array of the most frequently occurring numbers in a numeric data set.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MODE.MULT([10, 15, 20, 30, 10, 15,20]){"output":[10,15,20]}
155MODE.SNGLMODE.SNGL function returns the most frequently occurring number in a numeric data set.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MODE.SNGL([1,2,4,4,5,5,5,6]){"output":5}
156MONTHMONTH function extracts the month from a given date as number between 1 to 12.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MONTH("5/31/2012"){"output":5}
157MROUNDMROUND function returns a number rounded to a given multiple.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MROUND(21,14){"output":28}
158MULTINOMIALMULTINOMIAL function returns the ratio of the factorial of a sum of values to the product of factorials.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MULTINOMIAL(1,2,3){"output":60}
159MULTIPLYMULTIPLY function returns the product of two numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=MULTIPLY(25,25){"output":625}
160NENE function returns TRUE if two values are not equal and FALSE otherwise.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NE(25,25){"output":false}
161NEGBINOMDISTNEGBINOMDIST function calculates the Negative Binomial Distribution for a given set of parameters.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NEGBINOMDIST(10,5,0.25){"output":0.05504866037517786}
162NEGBINOM.DISTNEGBINOM.DIST function calculates the probability function or the cumulative distribution function for the Negative Binomial Distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NEGBINOM.DIST(10,5,0.25,FALSE){"output":0.05504866037517786}
163NETWORKDAYSNETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NETWORKDAYS("1/1/2021","1/31/2021"){"output":21}
164NOMINALNOMINAL function calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NOMINAL(0.1,4){"output":0.09645475633778045}
165NORM.DISTNORM.DIST function returns values for the normal probability density function and the normal cumulative distribution function.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORM.DIST(5,3,2,TRUE){"output":0.8413447460685429}
166NORM.INVNORM.INV function returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORM.INV(0.84134,3,2){"output":4.999960771932158}
167NORM.S.DISTNORM.S.DIST function returns output for the standard normal cumulative distribution and the standard normal probability density function.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORM.S.DIST(1.333333,TRUE){"output":0.9087887256040951}
168NORM.S.INVNORM.S.INV function returns the inverse of the standard normal cumulative distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORM.S.INV(0.908789){"output":1.3333346730441074}
169NORMDISTNORMDIST function returns the normal distribution for the specified mean and standard deviation.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORMDIST(42,40,1.5,FALSE){"output":0.10934004978399574}
170NORMINVNORMINV function returns the value of the inverse normal distribution function for the specified mean and standard deviation.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORMINV(0.908789,40,1.5){"output":42.00000200956616}
171NORMSINVNORMSINV function returns the value of the inverse standard normal distribution function for a specified value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NORMSINV(0.9088){"output":1.3334017452136095}
172NOTNOT function returns the opposite of a logical value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NOT(5){"output":false}
173NOWNOW function returns the current date and time as a date value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NOW(){"output":"2021-09-22T09:00:53.795Z"}
174NPERNPER function calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NPER(0.12/12, -100,-1000,10000,1){"output":59.67386567429457}
175NPVNPV function calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=NPV(0.08, 200, 250){"output":399.519890260631}
176OCT2BINOCT2BIN function converts an octal number into a binary number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=OCT2BIN(10){"output":"1000"}
177OCT2DECOCT2DEC function converts an octal number into a decimal number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=OCT2DEC(10){"output":8}
178OCT2HEXOCT2HEX function converts an octal number into a hexadecimal number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=OCT2HEX(751){"output":"1e9"}
179ODDODD function rounds a number up to the nearest odd integer.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ODD(2){"output":3}
180OROR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.https://api.rw001.com/rdn/api/adv/excelFormula?fm=OR(0,0){"output":false}
181PDURATIONPDURATION function returns the number of periods required by an investment to reach a specified value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PDURATION(0.025,2000,2200){"output":3.859866162622655}
182PERMUTPERMUT function returns the number of permutations for a given number of objects that can be selected from number objects.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PERMUT(3,2){"output":6}
183PERMUTATIONAPERMUTATIONA function returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PERMUTATIONA(2,2){"output":4}
184PHIPHI function returns the value of the density function for a standard normal distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PHI(0.75){"output":0.30113743215480443}
185PIPI function returns the value of the constant π (pi).https://api.rw001.com/rdn/api/adv/excelFormula?fm=PI()*10{"output":31.41592653589793}
186PMTPMT function calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PMT(0.08/12,10,10000){"output":-1037.0320893591606}
187POISSON.DISTPOISSON.DIST function returns the value of the Poisson distribution function or Poisson cumulative distribution function for a specified value and mean.https://api.rw001.com/rdn/api/adv/excelFormula?fm=POISSON.DIST(2,5,TRUE){"output":0.12465201948308113}
188POWPOW function returns a number raised to a power.https://api.rw001.com/rdn/api/adv/excelFormula?fm=POW(4,0.5){"output":2}
189POWERPOWER function returns a number raised to a given power.https://api.rw001.com/rdn/api/adv/excelFormula?fm=POWER(5,2){"output":25}
190PPMTPPMT function calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PPMT(0.1/12, 1, 2*12, 2000){"output":-75.62318600836673}
191PRODUCTPRODUCT function multiplies all the numbers given as arguments and returns the product.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PRODUCT(5,15,30){"output":2250}
193PROPERPROPER function capitalizes each word in a given text string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PROPER("this is a title"){"output":"This Is A Title"}
193PVPV function calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=PV(0.08/12, 12*20, 500 , 0){"output":-59777.14585118782}
194QUOTIENTQUOTIENT function returns the integer portion of division without the remainder.https://api.rw001.com/rdn/api/adv/excelFormula?fm=QUOTIENT(-20, 3){"output":-6}
195RADIANSRADIANS function converts degrees to radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=RADIANS(180){"output":3.141592653589793}
196RANDRAND function returns a random number between 0 and 1.https://api.rw001.com/rdn/api/adv/excelFormula?fm=RAND(){"output":0.20713942299078547}
197RANDBETWEENRANDBETWEEN function returns a random integer between two given numbers.https://api.rw001.com/rdn/api/adv/excelFormula?fm=RANDBETWEEN(-2,5){"output":-2}
198RATERATE function calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=RATE(4*12, -200, 8000)*12{"output":0.09241766985842984}
199REGEXMATCHREGEXMATCH function check whether a piece of text matches a regular expression.https://api.rw001.com/rdn/api/adv/excelFormula?fm=REGEXMATCH("this a test case", "as"){"output":true}
200REGEXREPLACEREGEXREPLACE function replaces part of a text string with a different text string using regular expressions.https://api.rw001.com/rdn/api/adv/excelFormula?fm=REGEXREPLACE("This is test string number 89","[0-9]+"," case"){"output":"This is test string number 89"}
201REPLACEREPLACE function replaces part of a text string with a different text string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=REPLACE("test string", 6, 6, "case"){"output":"test case"}
202REPTREPT function returns specified text repeated a number of times.https://api.rw001.com/rdn/api/adv/excelFormula?fm=REPT("a",5){"output":"aaaaa"}
203RIGHTRIGHT function returns a substring from the end of a specified string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=RIGHT("test string",5){"output":"tring"}
204ROMANROMAN function converts a number to a roman numeral as text.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ROMAN(35){"output":"XXXV"}
205ROUNDROUND function rounds a number to a specified number of digits.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ROUND(5.87567,3){"output":5.876}
206ROUNDDOWNROUNDDOWN function returns a number rounded down to a given number of places.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ROUNDDOWN(5.87567,3){"output":5.875}
207ROUNDUPROUNDUP function returns a number rounded up to a given number of decimal places.https://api.rw001.com/rdn/api/adv/excelFormula?fm=ROUNDUP(5.87547,3){"output":5.876}
208RRIRRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.https://api.rw001.com/rdn/api/adv/excelFormula?fm=RRI(5,1000,1200){"output":0.03713728933664817}
209SEARCHSEARCH function returns the position at which a string is first found within text, ignoring case.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SEARCH("t","test string",5){"output":7}
210SECSEC function returns the secant of an angle measured in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SEC(45){"output":1.9035944074044246}
211SECHSECH function returns the hyperbolic secant of an angle.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SECH(45){"output":5.725037161098787e-20}
212SIGNSIGN function returns the sign of a number as +1, -1 or 0.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SIGN(-200/10){"output":-1}
213SINSIN function returns the sine of an angle provided in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SIN(PI()/2){"output":1}
214SINHSINH function returns the hyperbolic sine of any real number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SINH(2){"output":3.626860407847019}
215SKEW.PSKEW.P function returns the skewness of a distribution, which is a measure of symmetry.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SKEW.P([3,4,5,2,3,4,5,6,7,8,9,10]){"output":0.416903553021822}
216SLNSLN function calculates the depreciation of an asset for one period using the straight-line method.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SLN(100,50,10){"output":5}
217SPLITSPLIT function divides text around a specified character or string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SPLIT("test string ","s"){"output":["te","t ","tring "]}
218SQRTSQRT function returns the positive square root of a positive number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SQRT(627){"output":25.03996805109783}
219SQRTPISQRTPI function returns the positive square root of the product of Pi and the given positive number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SQRTPI(2){"output":2.5066282746310002}
220STANDARDIZESTANDARDIZE function returns a normalized value based on the mean and standard deviation.https://api.rw001.com/rdn/api/adv/excelFormula?fm=STANDARDIZE(42,40,1.5){"output":1.3333333333333333}
221STDEV.SSTDEV.S function calculates the standard deviation for a sample set of data.https://api.rw001.com/rdn/api/adv/excelFormula?fm=STDEV.S(2,5,8,13,10){"output":4.277849927241488}
222STDEVASTDEVA function calculates standard deviation for a sample of data.https://api.rw001.com/rdn/api/adv/excelFormula?fm=STDEVA(2,5,8,13,10,"Google"){"output":4.926120853842978}
223STDEVPSTDEVP function calculates the standard deviation based on an entire population.https://api.rw001.com/rdn/api/adv/excelFormula?fm=STDEVP(2,5,8,13,10){"output":3.8262252939417984}
224STDEVPASTDEVPA function returns the standard deviation of a population based on an entire population of numbers, text, and logical values.https://api.rw001.com/rdn/api/adv/excelFormula?fm=STDEVPA(2,5,8,13,10,"Google",TRUE,FALSE){"output":4.648588495446763}
225SUBSTITUTESUBSTITUTE function replaces existing text with new text in a string.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SUBSTITUTE("test string","string","case"){"output":"test case"}
226SYDSYD function calculates the depreciation of an asset for a specified period using the sum of years digits method.https://api.rw001.com/rdn/api/adv/excelFormula?fm=SYD(300,750,10,1){"output":-81.81818181818181}
227TT function returns text when given a text value and an empty string ("") for numbers, dates, and the logical values TRUE and FALSE.https://api.rw001.com/rdn/api/adv/excelFormula?fm=T(TRUE){"output":""}
228T.DISTT.DIST function returns the right tailed Student distribution for a value x.https://api.rw001.com/rdn/api/adv/excelFormula?fm=T.DIST(8,3,FALSE){"output":0.0007369065168104779}
229T.DIST.2TT.DIST.2T function returns the two tailed Student distribution for a value x.https://api.rw001.com/rdn/api/adv/excelFormula?fm=T.DIST.2T(1,10){"output":0.34089313230222795}
230T.INVT.INV function returns the left-tailed inverse of the Student's t-distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=T.INV(0.75,2){"output":0.8164965809277775}
231T.INV.2TT.INV.2T function returns the two-tailed inverse of the Student's t-distribution.https://api.rw001.com/rdn/api/adv/excelFormula?fm=T.INV.2T( 0.5, 10 ){"output":0.6998120613126686}
232TANTAN function returns the tangent of an angle provided in radians.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TAN(45){"output":1.6197751905438615}
233TANHTANH function returns the hyperbolic tangent of any real number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TANH(0){"output":0}
234TBILLEQTBILLEQ function calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TBILLEQ("2/1/2011", "6/30/2011", 0.025){"output":0.025614035087719297}
235TBILLPRICETBILLPRICE function calculates the price of a US Treasury Bill based on discount rate.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TBILLPRICE("1/2/2010", "12/31/2010", 0.025){"output":97.50694444444444}
236TBILLYIELDTBILLYIELD function returns the yield for a Treasury bill.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TBILLYIELD("2/1/2011", "6/30/2011", 100){"output":0}
237TIMEConverts an hour, minute, and second into a time.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TIME(0,00,00){"output":0}
238TODAYTODAY function returns the current date as a date value.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TODAY(){"output":"2021-09-23T16:20:14.981Z"}
239TRIMTRIM function removes leading, trailing, and repeated spaces in text.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TRIM(" testcases "){"output":"testcases"}
240TRUETRUE function returns the Boolean value TRUE.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TRUE()){"output":true}
241TRUNCTRUNC function truncates a number to an integer by removing the fractional part of the number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=TRUNC(-8.9){"output":-8}
242UNICHARUNICHAR function returns the Unicode character for a number.https://api.rw001.com/rdn/api/adv/excelFormula?fm=UNICHAR(66){"output":"B"}
243UNICODEUNICODE function returns a number corresponding to a Unicode character.https://api.rw001.com/rdn/api/adv/excelFormula?fm=UNICODE("B"){"output":66}
244UNIQUEUNIQUE function returns a list of unique values in a list or range.https://api.rw001.com/rdn/api/adv/excelFormula?fm=UNIQUE([1,1,2,2,3,1]){"output":["1","2","3"]}
245UPPERUPPER function converts the text into uppercase.https://api.rw001.com/rdn/api/adv/excelFormula?fm=UPPER("test string"){"output":"TEST STRING"}
246VAR.PVAR.P function calculates variance based on the entire population (ignores logical values and text in the population).https://api.rw001.com/rdn/api/adv/excelFormula?fm=VAR.P(2,5,8,13,10){"output":14.64}
247VAR.SVAR.S returns sample variance for a supplied set of values,ignores logical values and text in the sample.https://api.rw001.com/rdn/api/adv/excelFormula?fm=VAR.S(2,5,8,13,10,TRUE,FALSE){"output":18.3}
248WEEKDAYWEEKDAY function returns a number representing the day of the week of the date provided.https://api.rw001.com/rdn/api/adv/excelFormula?fm=WEEKDAY("1/29/2021"){"output":6}
249WEEKNUMWEEKNUM function takes a date and returns a week number that corresponds to the week of year.https://api.rw001.com/rdn/api/adv/excelFormula?fm=WEEKNUM("1/31/21"){"output":6}
250WEIBULL.DISTWEIBULL.DIST function calculates the Weibull Probability Density Function or the Weibull Cumulative Distribution Function for a supplied set of parameters.https://api.rw001.com/rdn/api/adv/excelFormula?fm=WEIBULL.DIST(105,20,100,TRUE){"output":0.9295813900692769}
251WORKDAYWORKDAY function calculates the end date after a specified number of working days.https://api.rw001.com/rdn/api/adv/excelFormula?fm=WORKDAY("1/1/2021",5){"output":"2021-01-07T18:30:00.000Z"}
252XORXOR function returns a logical Exclusive Or of all arguments.https://api.rw001.com/rdn/api/adv/excelFormula?fm=XOR(TRUE,FALSE){"output":true}
253YEARYEAR function returns the year specified by a given date.https://api.rw001.com/rdn/api/adv/excelFormula?fm=YEAR("1/2/2011"){"output":2011}
254YEARFRACYEARFRAC function returns a decimal value that represents fractional years between two dates.https://api.rw001.com/rdn/api/adv/excelFormula?fm=YEARFRAC("1/1/2021","9/24/2021",1){"output":0.7287671232876712}