RDN Execute Excel Formula
The Excel formula webhook service can be used to execute the Excel formulas over Marketo fields. RDN provides 254 inbuilt Excel formulas in this service.
The Excel formula webhook service can be used to execute the Excel formulas over Marketo fields. RDN provides 254 inbuilt Excel formulas in this service.
The Excel formula webhook service can be used to execute the Excel formulas over Marketo fields. RDN provides 254 inbuilt Excel formulas in this service.
Users can see the example of Execute Excel Formula by clicking on API Details.
For example, you want to add a Behavioral score and a Demographic score in Marketo. In Webhook you can use the following:
URL:https://api.rightwave.com/rdn/api/adv/excelFormula?fm=SUM(lead.Behavior Score,lead.Demographic Score).
The webhook will return the result in JSON which can be mapped to the Lead Score {“output”:<Sum of Behavior score and Demographic score>}.
If the Behavior score is 10.1 and Demographic Score is 10 then you would get the result as 20.1 {“output”:20.1}.
Steps to follow in Marketo:
Service Name: Execute Excel Formula
Service Type: Advanced Service
Service Description: The Excel formula webhook service can be used to execute the Excel formulas over Marketo fields. RDN supports 254 Excel formulas. For example, users can use the SUM Excel formula to add the value of two fields score1 and score2, and save them in the total Score field of Marketo.
Please note that the request parameters values (in step 2) and Marketo Fields (in step 4) are just for examples. You have to enter the values as per your service requirement.
Steps to configure service Execute Excel Formula in Marketo
1. Go to Admin and click Webhooks. Click New Webhook.
2. Name and configure your webhook for Service Execute Excel Formula.
Webhook Name: Name of the webhook. In the above example, the Webhook name is the same as the Service name. Webhook name can be provided as per requirement.
URL: The URL of the Service Execute Excel Formula. The URL has domain and query parameters that will remain the same. You just have to change the parameter values with Marketo.
Token. To insert a token, click Insert Token.
Template: It will remain blank.
Request Token Encoding: It will remain None in case of POST, in case of GET field will be uneditable.
Response type: Select the response format as JSON.
Request Type: The Request Type will remain the same (i.e.) GET as given in the example.
- Add Authentication Header.
Please note that the auth-key shown above is the original auth-key. So, the same value of auth-key and Content-Type should be used while configuring Webhook as shown.
- Response Mappings: Response Mappings are created via a pairing of a Response Attribute. The Response attribute depends on the output you return from the Custom Service JavaScript function. Returning JSON from the Custom Service is recommended so you can easily map it with the Marketo field.
Below is the list of Excel formulas with their URL Example:
SN. | Formula | Description | URL Example | Output Example |
1 | SUM | SUM function adds the numerical values. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=SUM(-10.1,-10) | {“output”:-20.1} |
2 | ABS | ABS function returns the absolute value of a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ABS(-90) | {“output”:90} |
3 | ACCRINT | ACCRINT 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} |
4 | ACOS | ACOS function returns the inverse cosine of a value in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOS(1) | {“output”:0} |
5 | ACOSH | ACOSH function returns the inverse hyperbolic cosine of a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOSH(10) | {“output”:2.993222846126381} |
6 | ACOT | ACOT function returns the inverse cotangent of a value in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ACOT(-1) | {“output”:-0.7853981633974483} |
7 | ACOTH | ACOTH 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} |
8 | ADD | ADD function returns the sum of two numbers. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ADD(-1,-1) | {“output”:-2} |
9 | AND | AND 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} |
10 | ARABIC | ARABIC function converts roman numbers to arabic numbers. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ARABIC(“XIV”) | {“output”:14} |
11 | ASIN | ASIN function returns the inverse sine of a value in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ASIN(1) | {“output”:1.5707963267948966} |
12 | ASINH | ASINH function returns the inverse hyperbolic sine of a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ASINH(10) | {“output”:2.99822295029797} |
13 | ATAN | ATAN function returns the inverse tangent of a value in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ATAN(1) | {“output”:0.7853981633974483} |
14 | ATAN2 | ATAN2 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} |
15 | ATANH | ATANH function returns the inverse hyperbolic tangent of a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ATANH(-0.5) | {“output”:-0.5493061443340549} |
16 | AVEDEV | AVEDEV 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} |
17 | AVERAGE | AVERAGE 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} |
18 | AVERAGEA | AVERAGEA 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} |
19 | BASE | BASE 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″} |
20 | BESSELI | BESSELI function returns the modified Bessel function. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=BESSELI(1,1) | {“output”:0.5651590975819435} |
21 | BESSELJ | BESSELJ 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} |
22 | BESSELK | BESSELK 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} |
23 | BESSELY | BESSELY 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} |
24 | BETA.DIST | Beta.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} |
25 | BETA.INV | BETA.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} |
26 | BETAINV | BETAINV 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} |
27 | BETADIST | BETADIST 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} |
28 | BIN2DEC | BIN2DEC 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} |
29 | BIN2HEX | BIN2HEX 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”} |
30 | BIN2OCT | BIN2OCT function converts a binary number to octal. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=BIN2OCT(10011) | {“output”:”23″} |
31 | BINOM.DIST | BINOM.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} |
32 | BINOM.DIST.RANGE | BINOM.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} |
33 | BINOM.INV | BINOM.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} |
34 | BINOMDIST | BINOMDIST 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} |
35 | BITAND | BITAND 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} |
36 | BITLSHIFT | BITLSHIFT 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} |
37 | BITOR | BITOR 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} |
38 | BITRSHIFT | BITRSHIFT 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} |
39 | BITXOR | BITXOR 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} |
40 | CEILING | CEILING 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} |
41 | CHAR | CHAR function returns a character when given a valid character code. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHAR(65) | {“output”:”A”} |
42 | CHISQ.DIST | CHISQ.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} |
43 | CHISQ.DIST.RT | CHISQ.DIST.RT function calculates the right-tailed probability of the Chi-Square Distribution | https://api.rw001.com/rdn/api/adv/excelFormula?fm=CHISQ.DIST.RT(18.307,10) | {“output”:0.05000058909139815} |
44 | CHISQ.INV | CHISQ.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} |
45 | CHISQ.INV.RT | CHISQ.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} |
46 | CHOOSE | CHOOSE 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”} |
47 | CODE | CODE 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} |
48 | COMBIN | COMBIN 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} |
49 | COMBINA | Returns 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} |
50 | COMPLEX | COMPLEX 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”} |
51 | CONCATENATE | CONCATENATE 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”} |
52 | CONFIDENCE | CONFIDENCE 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} |
53 | CONFIDENCE.NORM | CONFIDENCE.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} |
54 | CONFIDENCE.T | CONFIDENCE.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} |
55 | CONVERT | CONVERT 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} |
56 | COS | COS function returns the cosine of an angle provided in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=COS(0) | {“output”:1} |
57 | COSH | COSH function returns the hyperbolic cosine of any real number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=COSH(4) | {“output”:27.308232836016487} |
58 | COT | COT function returns the cotangent of an angle provided in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=COT(45) | {“output”:0.6173696237835551} |
59 | COTH | COTH function returns the hyperbolic cotangent of any real number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=COTH(2) | {“output”:1.0373147207275482} |
60 | COUNT | COUNT 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} |
61 | COUNTA | COUNTA 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} |
62 | COUNTBLANK | COUNTBLANK function returns a count of empty cells in a range. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=COUNTBLANK(“”,””,””) | {“output”:3} |
63 | COUNTUNIQUE | COUNTUNIQUE 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} |
64 | CSC | CSC function returns the cosecant of an angle provided in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=CSC(15) | {“output”:1.5377805615408537} |
65 | CSCH | CSCH function returns the hyperbolic cosecant of any real number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=CSCH(1.5) | {“output”:0.46964244059522464} |
66 | CUMIPMT | CUMIPMT 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} |
67 | CUMPRINC | CUMPRINC 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} |
68 | DATEVALUE | DATEVALUE 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} |
69 | DAY | DAY 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} |
70 | DAYS | DAYS 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} |
71 | DB | DB 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} |
72 | DDB | DDB 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} |
73 | DEC2BIN | DEC2BIN function converts a decimal number to its binary equivalent. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEC2BIN(9, 4) | {“output”:”1001″} |
74 | DEC2HEX | DEC2HEX function converts a decimal number to its hexadecimal equivalent. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEC2HEX(100, 4) | {“output”:”0064″} |
75 | DEC2OCT | DEC2OCT function converts a decimal number to its octal equivalent. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEC2OCT(58, 3) | {“output”:”072″} |
76 | DECIMAL | DECIMAL 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} |
77 | DEGREES | DEGREES function converts an angle value in radians to degrees. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=DEGREES(0.7854) | {“output”:45.00010522957485} |
78 | DELTA | DELTA 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} |
79 | DEVSQ | DEVSQ 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} |
80 | DIVIDE | DIVIDE function returns one number divided by another. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=DIVIDE(20,3) | {“output”:6.666666666666667} |
81 | DOLLARDE | DOLLARDE 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} |
82 | DOLLARFR | DOLLARFR 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} |
83 | EFFECT | EFFECT 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} |
84 | EOMONTH | EOMONTH 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} |
85 | EQ | EQ 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} |
86 | ERF | ERF 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} |
87 | ERFC | ERFC 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} |
88 | EVEN | EVEN function returns number rounded up to the nearest even integer. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=EVEN(1.5) | {“output”:2} |
89 | EXACT | EXACT 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} |
90 | EXP | EXP 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} |
91 | EXPON.DIST | EXPON.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} |
92 | EXPONDIST | EXPONDIST 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} |
93 | F.DIST | F.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} |
94 | F.DIST.RT | F.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} |
95 | F.INV | F.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} |
96 | F.INV.RT | F.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} |
97 | FACT | FACT function returns the factorial of a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=FACT(5.5) | {“output”:120} |
98 | FACTDOUBLE | FACTDOUBLE function returns the double factorial of a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=FACTDOUBLE(8) | {“output”:384} |
99 | FDIST | FDIST 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} |
100 | FIND | FIND 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} |
101 | FINV | FINV 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} |
102 | FISHER | FISHER function returns the Fisher transformation of a specified value. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=FISHER(0.75) | {“output”:0.9729550745276566} |
103 | FISHERINV | FISHERINV 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} |
104 | FLOOR | FLOOR 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} |
105 | FV | FV 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} |
106 | GAMMA | GAMMA 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} |
107 | GAMMA.DIST | Gamma.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} |
108 | GAMMA.INV | GAMMA.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} |
109 | GAMMADIST | GAMMADIST function returns the Gamma Distribution. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMADIST(10,9,2,FALSE) | {“output”:0.03263901967407176} |
110 | GAMMAINV | GAMMAINV 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} |
111 | GAMMALN | GAMMALN function returns the natural logarithm of the gamma function. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=GAMMALN(4) | {“output”:1.791759469228055} |
112 | GAMMALN.PRECISE | GAMMALN.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} |
113 | GAUSS | GAUSS 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} |
114 | GCD | GCD 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} |
115 | GEOMEAN | GEOMEAN 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} |
116 | GESTEP | GESTEP 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} |
117 | GTE | GTE 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} |
118 | HARMEAN | HARMEAN 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} |
119 | HEX2BIN | HEX2BIN function converts a hexadecimal number to its binary equivalent. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=HEX2BIN(“F”, 8) | {“output”:”00001111″} |
120 | HEX2DEC | HEX2DEC function converts a hexadecimal number to its decimal equivalent. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=HEX2DEC(“A5”) | {“output”:165} |
121 | HEX2OCT | HEX2OCT function converts a hexadecimal number to its octal equivalent. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=HEX2OCT(“F”, 3) | {“output”:”017″} |
122 | HYPGEOM.DIST | HYPGEOM.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} |
123 | HYPGEOMDIST | HYPGEOMDIST function returns the hypergeometric distribution. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=HYPGEOMDIST(1,4,8,20) | {“output”:0.3632610939112487} |
124 | IF | IF 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”} |
125 | INT | INT 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} |
126 | IPMT | IPMT 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} |
127 | ISEVEN | ISEVEN 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} |
128 | ISLOGICAL | ISLOGICAL function checks whether a value is `TRUE` or `FALSE`. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ISLOGICAL(TRUE) | {“output”:true} |
129 | ISNONTEXT | ISNONTEXT 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} |
130 | ISNUMBER | ISNUMBER 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} |
131 | ISODD | ISODD 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} |
132 | ISOWEEKNUM | ISOWEEKNUM 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} |
133 | ISPMT | ISPMT 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} |
134 | ISTEXT | ISTEXT 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} |
135 | KURT | KURT 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} |
136 | LCM | LCM function returns the least common multiple of integers. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=LCM(10,100) | {“output”:100} |
137 | LEFT | LEFT 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”} |
138 | LEN | LEN 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} |
139 | LN | LN 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} |
140 | LOG | LOG 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} |
141 | LOG10 | LOG10 function returns the logarithm of a number, base 10. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=LOG10(86) | {“output”:1.9344984512435675} |
142 | LOGNORM.INV | LOGNORM.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} |
143 | LOWER | LOWER function converts a text string to all lowercase letters. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=LOWER(“Test CASE”) | {“output”:”test case”} |
144 | LT | LT 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} |
145 | LTE | LTE 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} |
146 | MAX | MAX 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} |
147 | MAXA | MAXA 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} |
148 | MEDIAN | MEDIAN 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} |
149 | MID | MID function returns a segment of a string. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=MID(“test case”,7,20) | {“output”:”ase”} |
150 | MIN | MIN 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} |
151 | MINA | MINA 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} |
152 | MINUS | MINUS function returns the difference of two numbers. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=MINUS(-11,-12) | {“output”:1} |
153 | MOD | MOD function returns the remainder of two numbers after division. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=MOD(10,-3) | {“output”:-1} |
154 | MODE.MULT | MODE.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]} |
155 | MODE.SNGL | MODE.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} |
156 | MONTH | MONTH 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} |
157 | MROUND | MROUND function returns a number rounded to a given multiple. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=MROUND(21,14) | {“output”:28} |
158 | MULTINOMIAL | MULTINOMIAL 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} |
159 | MULTIPLY | MULTIPLY function returns the product of two numbers. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=MULTIPLY(25,25) | {“output”:625} |
160 | NE | NE 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} |
161 | NEGBINOMDIST | NEGBINOMDIST 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} |
162 | NEGBINOM.DIST | NEGBINOM.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} |
163 | NETWORKDAYS | NETWORKDAYS 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} |
164 | NOMINAL | NOMINAL 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} |
165 | NORM.DIST | NORM.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} |
166 | NORM.INV | NORM.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} |
167 | NORM.S.DIST | NORM.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} |
168 | NORM.S.INV | NORM.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} |
169 | NORMDIST | NORMDIST 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} |
170 | NORMINV | NORMINV 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} |
171 | NORMSINV | NORMSINV 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} |
172 | NOT | NOT function returns the opposite of a logical value. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=NOT(5) | {“output”:false} |
173 | NOW | NOW 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”} |
174 | NPER | NPER 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} |
175 | NPV | NPV 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} |
176 | OCT2BIN | OCT2BIN function converts an octal number into a binary number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=OCT2BIN(10) | {“output”:”1000″} |
177 | OCT2DEC | OCT2DEC function converts an octal number into a decimal number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=OCT2DEC(10) | {“output”:8} |
178 | OCT2HEX | OCT2HEX function converts an octal number into a hexadecimal number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=OCT2HEX(751) | {“output”:”1e9″} |
179 | ODD | ODD function rounds a number up to the nearest odd integer. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ODD(2) | {“output”:3} |
180 | OR | OR 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} |
181 | PDURATION | PDURATION 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} |
182 | PERMUT | PERMUT 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} |
183 | PERMUTATIONA | PERMUTATIONA 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} |
184 | PHI | PHI 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} |
185 | PI | PI function returns the value of the constant π (pi). | https://api.rw001.com/rdn/api/adv/excelFormula?fm=PI()*10 | {“output”:31.41592653589793} |
186 | PMT | PMT 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} |
187 | POISSON.DIST | POISSON.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} |
188 | POW | POW function returns a number raised to a power. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=POW(4,0.5) | {“output”:2} |
189 | POWER | POWER function returns a number raised to a given power. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=POWER(5,2) | {“output”:25} |
190 | PPMT | PPMT 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} |
191 | PRODUCT | PRODUCT 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} |
193 | PROPER | PROPER 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”} |
193 | PV | PV 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} |
194 | QUOTIENT | QUOTIENT function returns the integer portion of division without the remainder. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=QUOTIENT(-20, 3) | {“output”:-6} |
195 | RADIANS | RADIANS function converts degrees to radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=RADIANS(180) | {“output”:3.141592653589793} |
196 | RAND | RAND function returns a random number between 0 and 1. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=RAND() | {“output”:0.20713942299078547} |
197 | RANDBETWEEN | RANDBETWEEN function returns a random integer between two given numbers. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=RANDBETWEEN(-2,5) | {“output”:-2} |
198 | RATE | RATE 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} |
199 | REGEXMATCH | REGEXMATCH 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} |
200 | REGEXREPLACE | REGEXREPLACE 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″} |
201 | REPLACE | REPLACE 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”} |
202 | REPT | REPT function returns specified text repeated a number of times. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=REPT(“a”,5) | {“output”:”aaaaa”} |
203 | RIGHT | RIGHT 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”} |
204 | ROMAN | ROMAN function converts a number to a roman numeral as text. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=ROMAN(35) | {“output”:”XXXV”} |
205 | ROUND | ROUND 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} |
206 | ROUNDDOWN | ROUNDDOWN 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} |
207 | ROUNDUP | ROUNDUP 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} |
208 | RRI | RRI 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} |
209 | SEARCH | SEARCH 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} |
210 | SEC | SEC function returns the secant of an angle measured in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=SEC(45) | {“output”:1.9035944074044246} |
211 | SECH | SECH function returns the hyperbolic secant of an angle. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=SECH(45) | {“output”:5.725037161098787e-20} |
212 | SIGN | SIGN 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} |
213 | SIN | SIN function returns the sine of an angle provided in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=SIN(PI()/2) | {“output”:1} |
214 | SINH | SINH function returns the hyperbolic sine of any real number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=SINH(2) | {“output”:3.626860407847019} |
215 | SKEW.P | SKEW.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} |
216 | SLN | SLN 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} |
217 | SPLIT | SPLIT 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 “]} |
218 | SQRT | SQRT function returns the positive square root of a positive number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=SQRT(627) | {“output”:25.03996805109783} |
219 | SQRTPI | SQRTPI 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} |
220 | STANDARDIZE | STANDARDIZE 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} |
221 | STDEV.S | STDEV.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} |
222 | STDEVA | STDEVA 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} |
223 | STDEVP | STDEVP 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} |
224 | STDEVPA | STDEVPA 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} |
225 | SUBSTITUTE | SUBSTITUTE 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”} |
226 | SYD | SYD 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} |
227 | T | T 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”:””} |
228 | T.DIST | T.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} |
229 | T.DIST.2T | T.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} |
230 | T.INV | T.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} |
231 | T.INV.2T | T.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} |
232 | TAN | TAN function returns the tangent of an angle provided in radians. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=TAN(45) | {“output”:1.6197751905438615} |
233 | TANH | TANH function returns the hyperbolic tangent of any real number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=TANH(0) | {“output”:0} |
234 | TBILLEQ | TBILLEQ 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} |
235 | TBILLPRICE | TBILLPRICE 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} |
236 | TBILLYIELD | TBILLYIELD 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} |
237 | TIME | Converts an hour, minute, and second into a time. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=TIME(0,00,00) | {“output”:0} |
238 | TODAY | TODAY 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”} |
239 | TRIM | TRIM function removes leading, trailing, and repeated spaces in text. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=TRIM(” testcases “) | {“output”:”testcases”} |
240 | TRUE | TRUE function returns the Boolean value TRUE. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=TRUE()) | {“output”:true} |
241 | TRUNC | TRUNC 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} |
242 | UNICHAR | UNICHAR function returns the Unicode character for a number. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=UNICHAR(66) | {“output”:”B”} |
243 | UNICODE | UNICODE function returns a number corresponding to a Unicode character. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=UNICODE(“B”) | {“output”:66} |
244 | UNIQUE | UNIQUE 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”]} |
245 | UPPER | UPPER function converts the text into uppercase. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=UPPER(“test string”) | {“output”:”TEST STRING”} |
246 | VAR.P | VAR.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} |
247 | VAR.S | VAR.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} |
248 | WEEKDAY | WEEKDAY 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} |
249 | WEEKNUM | WEEKNUM 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} |
250 | WEIBULL.DIST | WEIBULL.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} |
251 | WORKDAY | WORKDAY 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”} |
252 | XOR | XOR function returns a logical Exclusive Or of all arguments. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=XOR(TRUE,FALSE) | {“output”:true} |
253 | YEAR | YEAR function returns the year specified by a given date. | https://api.rw001.com/rdn/api/adv/excelFormula?fm=YEAR(“1/2/2011”) | {“output”:2011} |
254 | YEARFRAC | YEARFRAC 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} |