| Binding |
onDataChanged |
Occurs when data or formatting within the binding is changed. |
|
onSelectionChanged |
Occurs when the selected content in the binding is changed. |
| BindingDataChangedEventArgs |
binding |
Gets a temporary Binding object that contains the ID of the Binding object that raised the event. |
| BindingSelectionChangedEventArgs |
binding |
Gets a temporary Binding object that contains the ID of the Binding object that raised the event. |
|
columnCount |
Gets the number of columns selected. |
|
rowCount |
Gets the number of rows selected. |
|
startColumn |
Gets the index of the first column of the selection (zero-based). |
|
startRow |
Gets the index of the first row of the selection (zero-based). |
| Chart |
getImage(width?: number, height?: number, fittingMode?: Excel.ImageFittingMode) |
Renders the chart as a Base64-encoded image by scaling the chart to fit the specified dimensions. |
|
worksheet |
The worksheet containing the current chart. |
| Filter |
apply(criteria: Excel.FilterCriteria) |
Apply the given filter criteria on the given column. |
|
applyBottomItemsFilter(count: number) |
Apply a "Bottom Item" filter to the column for the given number of elements. |
|
applyBottomPercentFilter(percent: number) |
Apply a "Bottom Percent" filter to the column for the given percentage of elements. |
|
applyCellColorFilter(color: string) |
Apply a "Cell Color" filter to the column for the given color. |
|
applyCustomFilter(criteria1: string, criteria2?: string, oper?: Excel.FilterOperator) |
Apply an "Icon" filter to the column for the given criteria strings. |
|
applyDynamicFilter(criteria: Excel.DynamicFilterCriteria) |
Apply a "Dynamic" filter to the column. |
|
applyFontColorFilter(color: string) |
Apply a "Font Color" filter to the column for the given color. |
|
applyIconFilter(icon: Excel.Icon) |
Apply an "Icon" filter to the column for the given icon. |
|
applyTopItemsFilter(count: number) |
Apply a "Top Item" filter to the column for the given number of elements. |
|
applyTopPercentFilter(percent: number) |
Apply a "Top Percent" filter to the column for the given percentage of elements. |
|
applyValuesFilter(values: Array<string | FilterDatetime>) |
Apply a "Values" filter to the column for the given values. |
|
clear() |
Clear the filter on the given column. |
|
criteria |
The currently applied filter on the given column. |
| FilterCriteria |
color |
The HTML color string used to filter cells. |
|
criterion1 |
The first criterion used to filter data. |
|
criterion2 |
The second criterion used to filter data. |
|
dynamicCriteria |
The dynamic criteria from the Excel.DynamicFilterCriteria set to apply on this column. |
|
filterOn |
The property used by the filter to determine whether the values should stay visible. |
|
icon |
The icon used to filter cells. |
|
operator |
The operator used to combine criterion 1 and 2 when using custom filtering. |
|
values |
The set of values to be used as part of values filtering. |
| FilterDatetime |
date |
The date in ISO8601 format used to filter data. |
|
specificity |
How specific the date should be used to keep data. |
| FiveArrowsGraySet |
grayDownArrow |
|
|
grayDownInclineArrow |
|
|
graySideArrow |
|
|
grayUpArrow |
|
|
grayUpInclineArrow |
|
| FiveArrowsSet |
greenUpArrow |
|
|
redDownArrow |
|
|
yellowDownInclineArrow |
|
|
yellowSideArrow |
|
|
yellowUpInclineArrow |
|
| FiveBoxesSet |
fourFilledBoxes |
|
|
noFilledBoxes |
|
|
oneFilledBox |
|
|
threeFilledBoxes |
|
|
twoFilledBoxes |
|
| FiveQuartersSet |
blackCircle |
|
|
circleWithOneWhiteQuarter |
|
|
circleWithThreeWhiteQuarters |
|
|
circleWithTwoWhiteQuarters |
|
|
whiteCircleAllWhiteQuarters |
|
| FiveRatingSet |
fourBars |
|
|
noBars |
|
|
oneBar |
|
|
threeBars |
|
|
twoBars |
|
| FormatProtection |
formulaHidden |
Specifies if Excel hides the formula for the cells in the range. |
|
locked |
Specifies if Excel locks the cells in the object. |
| FourArrowsGraySet |
grayDownArrow |
|
|
grayDownInclineArrow |
|
|
grayUpArrow |
|
|
grayUpInclineArrow |
|
| FourArrowsSet |
greenUpArrow |
|
|
redDownArrow |
|
|
yellowDownInclineArrow |
|
|
yellowUpInclineArrow |
|
| FourRatingSet |
fourBars |
|
|
oneBar |
|
|
threeBars |
|
|
twoBars |
|
| FourRedToBlackSet |
blackCircle |
|
|
grayCircle |
|
|
pinkCircle |
|
|
redCircle |
|
| FourTrafficLightsSet |
blackCircleWithBorder |
|
|
greenCircle |
|
|
redCircleWithBorder |
|
|
yellowCircle |
|
| FunctionResult |
error |
Error value (such as "#DIV/0") representing the error. |
|
value |
The value of function evaluation. |
| Functions |
abs(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the absolute value of a number, a number without its sign. |
|
accrInt(issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, par: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, calcMethod?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the accrued interest for a security that pays periodic interest. |
|
accrIntM(issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, par: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the accrued interest for a security that pays interest at maturity. |
|
acos(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the arccosine of a number, in radians in the range 0 to Pi. |
|
acosh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse hyperbolic cosine of a number. |
|
acot(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the arccotangent of a number, in radians in the range 0 to Pi. |
|
acoth(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse hyperbolic cotangent of a number. |
|
amorDegrc(cost: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, datePurchased: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the prorated linear depreciation of an asset for each accounting period. |
|
amorLinc(cost: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, datePurchased: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the prorated linear depreciation of an asset for each accounting period. |
|
and(...values: Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. |
|
arabic(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a Roman numeral to Arabic. |
|
areas(reference: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of areas in a reference. |
|
asc(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Changes full-width (double-byte) characters to half-width (single-byte) characters. |
|
asin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2. |
|
asinh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse hyperbolic sine of a number. |
|
atan(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2. |
|
atan2(xNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi. |
|
atanh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse hyperbolic tangent of a number. |
|
aveDev(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the average of the absolute deviations of data points from their mean. |
|
average(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers. |
|
averageA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1. |
|
averageIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, averageRange?: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Finds average(arithmetic mean) for the cells specified by a given condition or criteria. |
|
averageIfs(averageRange: Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult | number | string | boolean>) |
Finds average(arithmetic mean) for the cells specified by a given set of conditions or criteria. |
|
bahtText(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a number to text (baht). |
|
base(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, radix: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, minLength?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a number into a text representation with the given radix (base). |
|
besselI(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the modified Bessel function In(x). |
|
besselJ(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Bessel function Jn(x). |
|
besselK(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the modified Bessel function Kn(x). |
|
besselY(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Bessel function Yn(x). |
|
beta_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, A?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, B?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the beta probability distribution function. |
|
beta_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, A?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, B?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the cumulative beta probability density function (BETA.DIST). |
|
bin2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a binary number to decimal. |
|
bin2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a binary number to hexadecimal. |
|
bin2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a binary number to octal. |
|
binom_Dist(numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the individual term binomial distribution probability. |
|
binom_Dist_Range(trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberS2?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the probability of a trial result using a binomial distribution. |
|
binom_Inv(trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
|
bitand(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a bitwise 'And' of two numbers. |
|
bitlshift(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, shiftAmount: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a number shifted left by shift_amount bits. |
|
bitor(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a bitwise 'Or' of two numbers. |
|
bitrshift(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, shiftAmount: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a number shifted right by shift_amount bits. |
|
bitxor(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a bitwise 'Exclusive Or' of two numbers. |
|
ceiling_Math(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mode?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
|
ceiling_Precise(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
|
char(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the character specified by the code number from the character set for your computer. |
|
chiSq_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the left-tailed probability of the chi-squared distribution. |
|
chiSq_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the right-tailed probability of the chi-squared distribution. |
|
chiSq_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the left-tailed probability of the chi-squared distribution. |
|
chiSq_Inv_RT(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the right-tailed probability of the chi-squared distribution. |
|
choose(indexNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult>) |
Chooses a value or action to perform from a list of values, based on an index number. |
|
clean(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Removes all nonprintable characters from text. |
|
code(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a numeric code for the first character in a text string, in the character set used by your computer. |
|
columns(array: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of columns in an array or reference. |
|
combin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of combinations for a given number of items. |
|
combina(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of combinations with repetitions for a given number of items. |
|
complex(realNum: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, iNum: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, suffix?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts real and imaginary coefficients into a complex number. |
|
concatenate(...values: Array<string | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Joins several text strings into one text string. |
|
confidence_Norm(alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, size: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the confidence interval for a population mean, using a normal distribution. |
|
confidence_T(alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, size: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the confidence interval for a population mean, using a Student's T distribution. |
|
convert(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fromUnit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, toUnit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a number from one measurement system to another. |
|
cos(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cosine of an angle. |
|
cosh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic cosine of a number. |
|
cot(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cotangent of an angle. |
|
coth(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic cotangent of a number. |
|
count(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Counts the number of cells in a range that contain numbers. |
|
countA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Counts the number of cells in a range that are not empty. |
|
countBlank(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Counts the number of empty cells in a specified range of cells. |
|
countIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Counts the number of cells within a range that meet the given condition. |
|
countIfs(...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult | number | string | boolean>) |
Counts the number of cells specified by a given set of conditions or criteria. |
|
coupDayBs(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of days from the beginning of the coupon period to the settlement date. |
|
coupDays(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of days in the coupon period that contains the settlement date. |
|
coupDaysNc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of days from the settlement date to the next coupon date. |
|
coupNcd(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the next coupon date after the settlement date. |
|
coupNum(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of coupons payable between the settlement date and maturity date. |
|
coupPcd(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the previous coupon date before the settlement date. |
|
csc(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cosecant of an angle. |
|
csch(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic cosecant of an angle. |
|
cumIPmt(rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cumulative interest paid between two periods. |
|
cumPrinc(rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cumulative principal paid on a loan between two periods. |
|
date(year: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, month: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, day: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number that represents the date in Microsoft Excel date-time code. |
|
datevalue(dateText: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code. |
|
daverage(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Averages the values in a column in a list or database that match conditions you specify. |
|
day(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the day of the month, a number from 1 to 31. |
|
days(endDate: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startDate: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of days between the two dates. |
|
days360(startDate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endDate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, method?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of days between two dates based on a 360-day year (twelve 30-day months). |
|
db(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, month?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |
|
dbcs(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. |
|
dcount(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify. |
|
dcountA(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Counts nonblank cells in the field (column) of records in the database that match the conditions you specify. |
|
ddb(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, factor?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. |
|
dec2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a decimal number to binary. |
|
dec2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a decimal number to hexadecimal. |
|
dec2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a decimal number to octal. |
|
decimal(number: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, radix: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a text representation of a number in a given base into a decimal number. |
|
degrees(angle: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts radians to degrees. |
|
delta(number1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Tests whether two numbers are equal. |
|
devSq(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the sum of squares of deviations of data points from their sample mean. |
|
dget(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Extracts from a database a single record that matches the conditions you specify. |
|
disc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the discount rate for a security. |
|
dmax(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the largest number in the field (column) of records in the database that match the conditions you specify. |
|
dmin(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the smallest number in the field (column) of records in the database that match the conditions you specify. |
|
dollar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a number to text, using currency format. |
|
dollarDe(fractionalDollar: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fraction: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. |
|
dollarFr(decimalDollar: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fraction: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. |
|
dproduct(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Multiplies the values in the field (column) of records in the database that match the conditions you specify. |
|
dstDev(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Estimates the standard deviation based on a sample from selected database entries. |
|
dstDevP(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Calculates the standard deviation based on the entire population of selected database entries. |
|
dsum(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Adds the numbers in the field (column) of records in the database that match the conditions you specify. |
|
duration(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, coupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the annual duration of a security with periodic interest payments. |
|
dvar(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Estimates variance based on a sample from selected database entries. |
|
dvarP(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Calculates variance based on the entire population of selected database entries. |
|
ecma_Ceiling(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
|
edate(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, months: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the serial number of the date that is the indicated number of months before or after the start date. |
|
effect(nominalRate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, npery: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the effective annual interest rate. |
|
eoMonth(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, months: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the serial number of the last day of the month before or after a specified number of months. |
|
erf(lowerLimit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, upperLimit?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the error function. |
|
erfC(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the complementary error function. |
|
erfC_Precise(X: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the complementary error function. |
|
erf_Precise(X: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the error function. |
|
error_Type(errorVal: string | number | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a number matching an error value. |
|
even(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a positive number up and negative number down to the nearest even integer. |
|
exact(text1: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, text2: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether two text strings are exactly the same, and returns TRUE or FALSE. |
|
exp(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns e raised to the power of a given number. |
|
expon_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lambda: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the exponential distribution. |
|
f_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets. |
|
f_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. |
|
f_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x. |
|
f_Inv_RT(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x. |
|
fact(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the factorial of a number, equal to 123*...* Number. |
|
factDouble(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the double factorial of a number. |
|
false() |
Returns the logical value FALSE. |
|
find(findText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, withinText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the starting position of one text string within another text string. |
|
findB(findText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, withinText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Finds the starting position of one text string within another text string. |
|
fisher(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Fisher transformation. |
|
fisherInv(y: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x. |
|
fixed(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, noCommas?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number to the specified number of decimals and returns the result as text with or without commas. |
|
floor_Math(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mode?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number down, to the nearest integer or to the nearest multiple of significance. |
|
floor_Precise(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number down, to the nearest integer or to the nearest multiple of significance. |
|
fv(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the future value of an investment based on periodic, constant payments and a constant interest rate. |
|
fvschedule(principal: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, schedule: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the future value of an initial principal after applying a series of compound interest rates. |
|
gamma(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Gamma function value. |
|
gammaLn(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the natural logarithm of the gamma function. |
|
gammaLn_Precise(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the natural logarithm of the gamma function. |
|
gamma_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the gamma distribution. |
|
gamma_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. |
|
gauss(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns 0.5 less than the standard normal cumulative distribution. |
|
gcd(...values: Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult>) |
Returns the greatest common divisor. |
|
geStep(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, step?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Tests whether a number is greater than a threshold value. |
|
geoMean(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the geometric mean of an array or range of positive numeric data. |
|
harMean(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals. |
|
hex2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a Hexadecimal number to binary. |
|
hex2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a hexadecimal number to decimal. |
|
hex2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a hexadecimal number to octal. |
|
hlookup(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, tableArray: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, rowIndexNum: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, rangeLookup?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify. |
|
hour(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). |
|
hypGeom_Dist(sampleS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberSample: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, populationS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberPop: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hypergeometric distribution. |
|
hyperlink(linkLocation: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, friendlyName?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet. |
|
if(logicalTest: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, valueIfTrue?: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult, valueIfFalse?: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. |
|
imAbs(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the absolute value (modulus) of a complex number. |
|
imArgument(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the argument q, an angle expressed in radians. |
|
imConjugate(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the complex conjugate of a complex number. |
|
imCos(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cosine of a complex number. |
|
imCosh(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic cosine of a complex number. |
|
imCot(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cotangent of a complex number. |
|
imCsc(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the cosecant of a complex number. |
|
imCsch(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic cosecant of a complex number. |
|
imDiv(inumber1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, inumber2: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the quotient of two complex numbers. |
|
imExp(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the exponential of a complex number. |
|
imLn(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the natural logarithm of a complex number. |
|
imLog10(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the base-10 logarithm of a complex number. |
|
imLog2(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the base-2 logarithm of a complex number. |
|
imPower(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a complex number raised to an integer power. |
|
imProduct(...values: Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult>) |
Returns the product of 1 to 255 complex numbers. |
|
imReal(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the real coefficient of a complex number. |
|
imSec(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the secant of a complex number. |
|
imSech(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic secant of a complex number. |
|
imSin(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the sine of a complex number. |
|
imSinh(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic sine of a complex number. |
|
imSqrt(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the square root of a complex number. |
|
imSub(inumber1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, inumber2: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the difference of two complex numbers. |
|
imSum(...values: Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult>) |
Returns the sum of complex numbers. |
|
imTan(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the tangent of a complex number. |
|
imaginary(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the imaginary coefficient of a complex number. |
|
int(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number down to the nearest integer. |
|
intRate(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, investment: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the interest rate for a fully invested security. |
|
ipmt(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate. |
|
irr(values: Excel.Range | Excel.RangeReference | Excel.FunctionResult, guess?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the internal rate of return for a series of cash flows. |
|
isErr(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is an error other than #N/A, and returns TRUE or FALSE. |
|
isError(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is an error, and returns TRUE or FALSE. |
|
isEven(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns TRUE if the number is even. |
|
isFormula(reference: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE. |
|
isLogical(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE. |
|
isNA(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is #N/A, and returns TRUE or FALSE. |
|
isNonText(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE. |
|
isNumber(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is a number, and returns TRUE or FALSE. |
|
isOdd(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns TRUE if the number is odd. |
|
isText(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is text, and returns TRUE or FALSE. |
|
isoWeekNum(date: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the ISO week number in the year for a given date. |
|
iso_Ceiling(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
|
ispmt(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the interest paid during a specific period of an investment. |
|
isref(value: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is a reference, and returns TRUE or FALSE. |
|
kurt(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the kurtosis of a data set. |
|
large(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the k-th largest value in a data set. |
|
lcm(...values: Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult>) |
Returns the least common multiple. |
|
left(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numChars?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the specified number of characters from the start of a text string. |
|
leftb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numBytes?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the specified number of characters from the start of a text string. |
|
len(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of characters in a text string. |
|
lenb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of characters in a text string. |
|
ln(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the natural logarithm of a number. |
|
log(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, base?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the logarithm of a number to the base you specify. |
|
log10(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the base-10 logarithm of a number. |
|
logNorm_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. |
|
logNorm_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. |
|
lookup(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lookupVector: Excel.Range | Excel.RangeReference | Excel.FunctionResult, resultVector?: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Looks up a value either from a one-row or one-column range or from an array. |
|
lower(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts all letters in a text string to lowercase. |
|
match(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lookupArray: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, matchType?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the relative position of an item in an array that matches a specified value in a specified order. |
|
max(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the largest value in a set of values. |
|
maxA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the largest value in a set of values. |
|
mduration(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, coupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Macauley modified duration for a security with an assumed par value of $100. |
|
median(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the median, or the number in the middle of the set of given numbers. |
|
mid(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numChars: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the characters from the middle of a text string, given a starting position and length. |
|
midb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numBytes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns characters from the middle of a text string, given a starting position and length. |
|
min(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the smallest number in a set of values. |
|
minA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the smallest value in a set of values. |
|
minute(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the minute, a number from 0 to 59. |
|
mirr(values: Excel.Range | Excel.RangeReference | Excel.FunctionResult, financeRate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, reinvestRate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash. |
|
mod(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, divisor: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the remainder after a number is divided by a divisor. |
|
month(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the month, a number from 1 (January) to 12 (December). |
|
mround(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, multiple: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a number rounded to the desired multiple. |
|
multiNomial(...values: Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult>) |
Returns the multinomial of a set of numbers. |
|
n(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero). |
|
na() |
Returns the error value #N/A (value not available). |
|
negBinom_Dist(numberF: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success. |
|
networkDays(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of whole workdays between two dates. |
|
networkDays_Intl(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, weekend?: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of whole workdays between two dates with custom weekend parameters. |
|
nominal(effectRate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, npery: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the annual nominal interest rate. |
|
norm_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the normal distribution for the specified mean and standard deviation. |
|
norm_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. |
|
norm_S_Dist(z: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the standard normal distribution (has a mean of zero and a standard deviation of one). |
|
norm_S_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one). |
|
not(logical: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Changes FALSE to TRUE, or TRUE to FALSE. |
|
now() |
Returns the current date and time formatted as a date and time. |
|
nper(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
|
npv(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values). |
|
numberValue(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimalSeparator?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, groupSeparator?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts text to number in a locale-independent manner. |
|
oct2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts an octal number to binary. |
|
oct2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts an octal number to decimal. |
|
oct2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts an octal number to hexadecimal. |
|
odd(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a positive number up and negative number down to the nearest odd integer. |
|
oddFPrice(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstCoupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the price per $100 face value of a security with an odd first period. |
|
oddFYield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstCoupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the yield of a security with an odd first period. |
|
oddLPrice(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lastInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the price per $100 face value of a security with an odd last period. |
|
oddLYield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lastInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the yield of a security with an odd last period. |
|
or(...values: Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. |
|
pduration(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of periods required by an investment to reach a specified value. |
|
percentRank_Exc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. |
|
percentRank_Inc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. |
|
percentile_Exc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |
|
percentile_Inc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. |
|
permut(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of permutations for a given number of objects that can be selected from the total objects. |
|
permutationa(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects. |
|
phi(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the value of the density function for a standard normal distribution. |
|
pi() |
Returns the value of Pi, 3.14159265358979, accurate to 15 digits. |
|
pmt(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Calculates the payment for a loan based on constant payments and a constant interest rate. |
|
poisson_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Poisson distribution. |
|
power(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, power: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the result of a number raised to a power. |
|
ppmt(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate. |
|
price(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the price per $100 face value of a security that pays periodic interest. |
|
priceDisc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the price per $100 face value of a discounted security. |
|
priceMat(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the price per $100 face value of a security that pays interest at maturity. |
|
product(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Multiplies all the numbers given as arguments. |
|
proper(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a text string to proper case; the first letter in each word to uppercase, and all other letters to lowercase. |
|
pv(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the present value of an investment: the total amount that a series of future payments is worth now. |
|
quartile_Exc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, quart: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the quartile of a data set, based on percentile values from 0..1, exclusive. |
|
quartile_Inc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, quart: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the quartile of a data set, based on percentile values from 0..1, inclusive. |
|
quotient(numerator: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, denominator: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the integer portion of a division. |
|
radians(angle: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts degrees to radians. |
|
rand() |
Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation). |
|
randBetween(bottom: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, top: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a random number between the numbers you specify. |
|
rank_Avg(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, ref: Excel.Range | Excel.RangeReference | Excel.FunctionResult, order?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned. |
|
rank_Eq(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, ref: Excel.Range | Excel.RangeReference | Excel.FunctionResult, order?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. |
|
rate(nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, guess?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the interest rate per period of a loan or an investment. |
|
received(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, investment: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the amount received at maturity for a fully invested security. |
|
replace(oldText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numChars: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Replaces part of a text string with a different text string. |
|
replaceB(oldText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numBytes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Replaces part of a text string with a different text string. |
|
rept(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberTimes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Repeats text a given number of times. |
|
right(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numChars?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the specified number of characters from the end of a text string. |
|
rightb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numBytes?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the specified number of characters from the end of a text string. |
|
roman(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, form?: boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts an Arabic numeral to Roman, as text. |
|
round(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number to a specified number of digits. |
|
roundDown(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number down, toward zero. |
|
roundUp(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Rounds a number up, away from zero. |
|
rows(array: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of rows in a reference or array. |
|
rri(nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns an equivalent interest rate for the growth of an investment. |
|
sec(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the secant of an angle. |
|
sech(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic secant of an angle. |
|
second(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the second, a number from 0 to 59. |
|
seriesSum(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, m: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, coefficients: Excel.Range | string | number | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the sum of a power series based on the formula. |
|
sheet(value?: Excel.Range | string | Excel.RangeReference | Excel.FunctionResult) |
Returns the sheet number of the referenced sheet. |
|
sheets(reference?: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number of sheets in a reference. |
|
sign(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative. |
|
sin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the sine of an angle. |
|
sinh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic sine of a number. |
|
skew(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean. |
|
skew_p(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean. |
|
sln(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the straight-line depreciation of an asset for one period. |
|
small(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the k-th smallest value in a data set. |
|
sqrt(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the square root of a number. |
|
sqrtPi(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the square root of (number * Pi). |
|
stDevA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Estimates standard deviation based on a sample, including logical values and text. |
|
stDevPA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Calculates standard deviation based on an entire population, including logical values and text. |
|
stDev_P(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text). |
|
stDev_S(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Estimates standard deviation based on a sample (ignores logical values and text in the sample). |
|
standardize(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a normalized value from a distribution characterized by a mean and standard deviation. |
|
substitute(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, oldText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, instanceNum?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Replaces existing text with new text in a text string. |
|
subtotal(functionNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns a subtotal in a list or database. |
|
sum(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Adds all the numbers in a range of cells. |
|
sumIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, sumRange?: Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Adds the cells specified by a given condition or criteria. |
|
sumIfs(sumRange: Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult | number | string | boolean>) |
Adds the cells specified by a given set of conditions or criteria. |
|
sumSq(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns the sum of the squares of the arguments. |
|
syd(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the sum-of-years' digits depreciation of an asset for a specified period. |
|
t(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not. |
|
t_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the left-tailed Student's t-distribution. |
|
t_Dist_2T(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the two-tailed Student's t-distribution. |
|
t_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the right-tailed Student's t-distribution. |
|
t_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the left-tailed inverse of the Student's t-distribution. |
|
t_Inv_2T(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the two-tailed inverse of the Student's t-distribution. |
|
tan(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the tangent of an angle. |
|
tanh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the hyperbolic tangent of a number. |
|
tbillEq(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the bond-equivalent yield for a treasury bill. |
|
tbillPrice(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the price per $100 face value for a treasury bill. |
|
tbillYield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the yield for a treasury bill. |
|
text(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, formatText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a value to text in a specific number format. |
|
time(hour: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, minute: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, second: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format. |
|
timevalue(timeText: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). |
|
today() |
Returns the current date formatted as a date. |
|
trim(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Removes all spaces from a text string except for single spaces between words. |
|
trimMean(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, percent: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the mean of the interior portion of a set of data values. |
|
true() |
Returns the logical value TRUE. |
|
trunc(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Truncates a number to an integer by removing the decimal, or fractional, part of the number. |
|
type(value: boolean | string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64; compound data = 128. |
|
unichar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Unicode character referenced by the given numeric value. |
|
unicode(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the number (code point) corresponding to the first character of the text. |
|
upper(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a text string to all uppercase letters. |
|
usdollar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a number to text, using currency format. |
|
value(text: string | boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Converts a text string that represents a number to a number. |
|
varA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Estimates variance based on a sample, including logical values and text. |
|
varPA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Calculates variance based on the entire population, including logical values and text. |
|
var_P(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Calculates variance based on the entire population (ignores logical values and text in the population). |
|
var_S(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Estimates variance based on a sample (ignores logical values and text in the sample). |
|
vdb(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startPeriod: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endPeriod: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, factor?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, noSwitch?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. |
|
vlookup(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, tableArray: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, colIndexNum: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, rangeLookup?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. |
|
weekNum(serialNumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, returnType?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the week number in the year. |
|
weekday(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, returnType?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns a number from 1 to 7 identifying the day of the week of a date. |
|
weibull_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the Weibull distribution. |
|
workDay(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, days: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the serial number of the date before or after a specified number of workdays. |
|
workDay_Intl(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, days: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, weekend?: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. |
|
xirr(values: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult, dates: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult, guess?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the internal rate of return for a schedule of cash flows. |
|
xnpv(rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, values: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult, dates: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult) |
Returns the net present value for a schedule of cash flows. |
|
xor(...values: Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult>) |
Returns a logical 'Exclusive Or' of all arguments. |
|
year(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the year of a date, an integer in the range 1900 - 9999. |
|
yearFrac(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the year fraction representing the number of whole days between start_date and end_date. |
|
yield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the yield on a security that pays periodic interest. |
|
yieldDisc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the annual yield for a discounted security. |
|
yieldMat(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the annual yield of a security that pays interest at maturity. |
|
z_Test(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, sigma?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult) |
Returns the one-tailed P-value of a z-test. |
| Icon |
index |
Specifies the index of the icon in the given set. |
| IconCollections |
fiveArrows |
|
|
fiveArrowsGray |
|
|
fiveBoxes |
[Api set: ExcelApi 1.2] |
|
fiveQuarters |
|
|
fiveRating |
|
|
fourArrows |
|
|
fourArrowsGray |
|
|
fourRating |
|
|
fourRedToBlack |
|
|
fourTrafficLights |
|
|
threeArrows |
|
|
threeArrowsGray |
|
|
threeFlags |
|
|
threeSigns |
|
|
threeStars |
|
|
threeSymbols2 |
|
|
threeSymbols |
|
|
threeTrafficLights1 |
|
|
threeTrafficLights2 |
|
|
threeTriangles |
|
| Range |
columnHidden |
Represents if all columns in the current range are hidden. |
|
formulasR1C1 |
Represents the formula in R1C1-style notation. |
|
getColumnsAfter(count?: number) |
Gets a certain number of columns to the right of the current Range object. |
|
getColumnsBefore(count?: number) |
Gets a certain number of columns to the left of the current Range object. |
|
getResizedRange(deltaRows: number, deltaColumns: number) |
Gets a Range object similar to the current Range object, but with its bottom-right corner expanded (or contracted) by some number of rows and columns. |
|
getRowsAbove(count?: number) |
Gets a certain number of rows above the current Range object. |
|
getRowsBelow(count?: number) |
Gets a certain number of rows below the current Range object. |
|
getUsedRange(valuesOnly?: boolean) |
Returns the used range of the given range object. |
|
hidden |
Represents if all cells in the current range are hidden. |
|
merge(across?: boolean) |
Merge the range cells into one region in the worksheet. |
|
rowHidden |
Represents if all rows in the current range are hidden. |
|
sort |
Represents the range sort of the current range. |
|
unmerge() |
Unmerge the range cells into separate cells. |
| RangeFormat |
autofitColumns() |
Changes the width of the columns of the current range to achieve the best fit, based on the current data in the columns. |
|
autofitRows() |
Changes the height of the rows of the current range to achieve the best fit, based on the current data in the columns. |
|
columnWidth |
Specifies the width of all columns within the range. |
|
protection |
Returns the format protection object for a range. |
|
rowHeight |
The height of all rows in the range. |
| RangeReference |
address |
The address of the range, for example "SheetName!A1:B5". |
| RangeSort |
apply(fields: Excel.SortField[], matchCase?: boolean, hasHeaders?: boolean, orientation?: Excel.SortOrientation, method?: Excel.SortMethod) |
Perform a sort operation. |
| SelectionChangedEventArgs |
workbook |
Gets the workbook object that raised the selection changed event. |
| SortField |
ascending |
Specifies if the sorting is done in an ascending fashion. |
|
color |
Specifies the color that is the target of the condition if the sorting is on font or cell color. |
|
dataOption |
Represents additional sorting options for this field. |
|
icon |
Specifies the icon that is the target of the condition, if the sorting is on the cell's icon. |
|
key |
Specifies the column (or row, depending on the sort orientation) that the condition is on. |
|
sortOn |
Specifies the type of sorting of this condition. |
| Table |
clearFilters() |
Clears all the filters currently applied on the table. |
|
convertToRange() |
Converts the table into a normal range of cells. |
|
reapplyFilters() |
Reapplies all the filters currently on the table. |
|
sort |
Represents the sorting for the table. |
|
worksheet |
The worksheet containing the current table. |
| TableColumn |
filter |
Retrieves the filter applied to the column. |
| TableSort |
apply(fields: Excel.SortField[], matchCase?: boolean, method?: Excel.SortMethod) |
Perform a sort operation. |
|
clear() |
Clears the sorting that is currently on the table. |
|
fields |
Specifies the current conditions used to last sort the table. |
|
matchCase |
Specifies if the casing impacts the last sort of the table. |
|
method |
Represents the Chinese character ordering method last used to sort the table. |
|
reapply() |
Reapplies the current sorting parameters to the table. |
| ThreeArrowsGraySet |
grayDownArrow |
|
|
graySideArrow |
|
|
grayUpArrow |
|
| ThreeArrowsSet |
greenUpArrow |
|
|
redDownArrow |
|
|
yellowSideArrow |
|
| ThreeFlagsSet |
greenFlag |
|
|
redFlag |
|
|
yellowFlag |
|
| ThreeSignsSet |
greenCircle |
|
|
redDiamond |
|
|
yellowTriangle |
|
| ThreeStarsSet |
goldStar |
|
|
halfGoldStar |
|
|
silverStar |
|
| ThreeSymbols2Set |
greenCheck |
|
|
redCross |
|
|
yellowExclamation |
|
| ThreeSymbolsSet |
greenCheckSymbol |
|
|
redCrossSymbol |
|
|
yellowExclamationSymbol |
|
| ThreeTrafficLights1Set |
greenCircle |
|
|
redCircleWithBorder |
|
|
yellowCircle |
|
| ThreeTrafficLights2Set |
greenTrafficLight |
|
|
redTrafficLight |
|
|
yellowTrafficLight |
|
| ThreeTrianglesSet |
greenUpTriangle |
|
|
redDownTriangle |
|
|
yellowDash |
|
| Workbook |
functions |
Represents a collection of worksheet functions that can be used for computation. |
|
onSelectionChanged |
Occurs when the selection in the document is changed. |
| Worksheet |
getUsedRange(valuesOnly?: boolean) |
The used range is the smallest range that encompasses any cells that have a value or formatting assigned to them. |
|
protection |
Returns the sheet protection object for a worksheet. |
| WorksheetProtection |
options |
Specifies the protection options for the worksheet. |
|
protect(options?: Excel.WorksheetProtectionOptions, password?: string) |
Protects a worksheet. |
|
protected |
Specifies if the worksheet is protected. |
| WorksheetProtectionOptions |
allowAutoFilter |
Represents the worksheet protection option allowing use of the AutoFilter feature. |
|
allowDeleteColumns |
Represents the worksheet protection option allowing deleting of columns. |
|
allowDeleteRows |
Represents the worksheet protection option allowing deleting of rows. |
|
allowFormatCells |
Represents the worksheet protection option allowing formatting of cells. |
|
allowFormatColumns |
Represents the worksheet protection option allowing formatting of columns. |
|
allowFormatRows |
Represents the worksheet protection option allowing formatting of rows. |
|
allowInsertColumns |
Represents the worksheet protection option allowing inserting of columns. |
|
allowInsertHyperlinks |
Represents the worksheet protection option allowing inserting of hyperlinks. |
|
allowInsertRows |
Represents the worksheet protection option allowing inserting of rows. |
|
allowPivotTables |
Represents the worksheet protection option allowing use of the PivotTable feature. |
|
allowSort |
Represents the worksheet protection option allowing use of the sort feature. |