Version

WinCalcManager Resource Strings Reference

You can quickly and easily modify any resource string value that is displayed to a user by a control/component. Resource strings include items such as dialog box captions, warning messages, alerts, etc.

The following table lists the names of the resource strings that are used by this assembly, along with the string’s default text value.

Resource String Name Default Value

CalcSettingsPropertyName_Not_Set

PropertyName not set or property could not be found on CalcSettings.

Error_Internal

An internal error occurred in method {0}.

Error_InvalidFunction

Invalid function '{0}' at line {1} col {2}.

Error_InvalidFunctionArgCountTooFew

The function '{0}' referenced at line {1} col {2} does not contain the correct number of arguments. The function requires a minimum of {3} parameter(s).

Error_InvalidFunctionArgCountTooMany

The function '{0}' referenced at line {1} col {2} does not contain the correct number of arguments. The argument count should not exceed {3} parameter(s).

Error_InvalidOperatorArgCount

The '{0}' function must accept {1} arguments.

Error_NullFunctionResult

The evaluation of '{0}' returned a null value.

Error_ParseRef

Unknown reference at line {0} col {1}.

Error_UnresolvedExternal

Unresolved external reference

FormulaCircularityError_Default_Message

A Formula Circularity has been detected in the formula for [{0}]. The Formula is: {1}. No calculations can be performed by the CalcEngine while a Circularity exists.

FormulaCircularityError_Message_Title

Circularity Error

FormulaSyntaxError_Default_Message

A syntax error occured while compiling a formula for: {0}. The error is: {1}

FormulaSyntaxError_Message_Title

Syntax Error

Func_abs_Arg_0

number

Func_abs_ArgDesc_0

Number is the real number of which you want the absolute value

Func_abs_Category

Math

Func_abs_CategoryURL

Math

Func_abs_Desc

Returns the absolute value of a number. The absolute value of a number is the number without its sign

Func_acos_Arg_0

number

Func_acos_ArgDesc_0

Number is the cosine of the angle you want and must be from -1 to 1 radians.

Func_acos_Category

Math

Func_acos_CategoryURL

Math

Func_acos_Desc

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. To convert the result from radians to degrees, multiply it by 180/PI().

Func_acosh_Arg_0

number

Func_acosh_ArgDesc_0

Number is a real number greater than 1 for which you want the inverse hyperbolic cosine

Func_acosh_Category

Math

Func_acosh_CategoryURL

Math

Func_acosh_Desc

Returns the inverse hyperbolic cosine of the given number

Func_and_Arg_0

logical{0}

Func_and_ArgDesc_0

Logical1, logical2, …​ are conditions you want to test that can be either TRUE or FALSE

Func_and_Category

Logical

Func_and_CategoryURL

Logical

Func_and_Desc

Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE

Func_asin_Arg_0

number

Func_asin_ArgDesc_0

Number is the sine of the angle you want and must be from -1 to 1 radians.

Func_asin_Category

Math

Func_asin_CategoryURL

Math

Func_asin_Desc

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arcsine in degrees, multiply the result by 180/PI()

Func_asinh_Arg_0

number

Func_asinh_ArgDesc_0

Number is a real number for which you want the inverse hyperbolic sine

Func_asinh_Category

Math

Func_asinh_CategoryURL

Math

Func_asinh_Desc

Returns the inverse hyperbolic sine of the given number

Func_atan_Arg_0

number

Func_atan_ArgDesc_0

Number is the tangent of the angle you want

Func_atan_Category

Math

Func_atan_CategoryURL

Math

Func_atan_Desc

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arctangent in degrees, multiply the result by 180/PI().

Func_atan2_Arg_0

x

Func_atan2_Arg_1

y

Func_atan2_ArgDesc_0

X is the x-coordinate of the point

Func_atan2_ArgDesc_1

Y is the y-coordinate of the point

Func_atan2_Category

Math

Func_atan2_CategoryURL

Math

Func_atan2_Desc

Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). The angle is given in radians between -pi and pi, excluding -pi.

Func_atanh_Arg_0

number

Func_atanh_ArgDesc_0

Number is a real number between -1 and 1 for which you want the inverse hyperbolic tangent

Func_atanh_Category

Math

Func_atanh_CategoryURL

Math

Func_atanh_Desc

Returns the inverse hyperbolic tangent of the given number

Func_average_Arg_0

number{0}

Func_average_ArgDesc_0

Number1, number2, …​ are numeric arguments for which you want the average

Func_average_Category

Statistical

Func_average_CategoryURL

Statistical

Func_average_Desc

Returns the average

Func_bin2dec_Arg_0

Number

Func_bin2dec_ArgDesc_0

Number is a string represeting a binary number.

Func_bin2dec_Category

Engineering

Func_bin2dec_CategoryURL

Engineering

Func_bin2dec_Desc

Returns the decimal value of a string representation of a number in a binary system.

Func_bin2hex_Arg_0

Number

Func_bin2hex_Arg_1

Places

Func_bin2hex_ArgDesc_0

Number is the value to be converted.

Func_bin2hex_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_bin2hex_Category

Engineering

Func_bin2hex_CategoryURL

Engineering

Func_bin2hex_Desc

Converts a string representing a binary number to a string representing the same number in the hexadecimal number system.

Func_bin2oct_Arg_0

Number

Func_bin2oct_Arg_1

Places

Func_bin2oct_ArgDesc_0

Number is the value to be converted.

Func_bin2oct_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_bin2oct_Category

Engineering

Func_bin2oct_CategoryURL

Engineering

Func_bin2oct_Desc

Converts a string representing a binary number to a string representing the same number in the octal number system.

Func_CategoryURL_Template

ms-help://INFRAGISTICS_HELP/Infragisticsv{2}{3}/Win/WinElements/WinCalcManager_{0}_Functions.html#FUNC_{1}

Func_ceiling_Arg_0

number

Func_ceiling_Arg_1

significance

Func_ceiling_ArgDesc_0

Number is the numeric value you want to round

Func_ceiling_ArgDesc_1

Significance is the number to which to round. If omitted, rounding will be done to the nearest whole number.

Func_ceiling_Category

Math

Func_ceiling_CategoryURL

Math

Func_ceiling_Desc

Returns the smallest multiple of the significance (defaults to 1) greater than or equal to the given number.

Func_char_Arg_0

charCode

Func_char_ArgDesc_0

The number to be converted to a character.

Func_char_Category

TextAndData

Func_char_CategoryURL

Text_and_Data

Func_char_Desc

Returns the character specified by the code number from the character set for your computer.

Func_choose_Arg_0

IndexNum

Func_choose_Arg_1

Value{0}

Func_choose_ArgDesc_0

The 1-based index into the rest of the arguments for the value to use.

Func_choose_ArgDesc_1

Value1, Value2, …​, ValueN is any number of values.

Func_choose_Category

LookupAndReference

Func_choose_CategoryURL

Lookup_And_Reference

Func_choose_Desc

Returns one of the values provided in its arguments based on the number in the first argument.

Func_code_Arg_0

string

Func_code_ArgDesc_0

The string which will have it’s first character evaluated.

Func_code_Category

TextAndData

Func_code_CategoryURL

Text_and_Data

Func_code_Desc

Returns a numeric code for the first character in a text string using the character set used by your computer.

Func_combin_Arg_0

Number

Func_combin_Arg_1

NumberChosen

Func_combin_ArgDesc_0

Number is the number of items.

Func_combin_ArgDesc_1

NumberChosen is the number of items chosen in each combination.

Func_combin_Category

Math

Func_combin_CategoryURL

Math

Func_combin_Desc

Returns the number of possible combinations given a set of items and a number of chosen items from that set.

Func_complex_Arg_0

RealNumber

Func_complex_Arg_1

ImaginaryNumber

Func_complex_Arg_2

Suffix

Func_complex_ArgDesc_0

RealNumber is the real coefficient of the complex number.

Func_complex_ArgDesc_1

ImaginaryNumber is the imaginary coefficient of the number.

Func_complex_ArgDesc_2

Suffix specifies the suffix to use. The acceptable values are "i" or "j". If omitted, "i" is used. Note that the suffix is case-sensitive; upper case "I" and "J" are not allowed and will result in a #VALUE error.

Func_complex_Category

Engineering

Func_complex_CategoryURL

Engineering

Func_complex_Desc

Returns a complex number represented as a string in the format "x + yi" or "x + yj" by comining a real and imaginary number.

Func_concatenate_Arg_0

text{0}

Func_concatenate_ArgDesc_0

Text1, text2, …​ are one or more text items to be joined into a single text item

Func_concatenate_Category

TextAndData

Func_concatenate_CategoryURL

Text_and_Data

Func_concatenate_Desc

Joins all the arguments into one string.

Func_convert_Arg_0

Number

Func_convert_Arg_1

FromUnit

Func_convert_Arg_2

ToUnit

Func_convert_ArgDesc_0

Number is the value to convert.

Func_convert_ArgDesc_1

FromUnit is the unit in which the number is given. Weight and mass units: "g" = gram "sg" = slug "lbm" = pound mass (avoirdupois) "u" = U (atomic mass unit) "ozm" = Ounce mass (avoirdupois) Distance units: "m" = Meter "mi" = Statute mile "Nmi" = Nautical mile "in" = Inch "ft" = Foot "yd" = Yard "ang" = Angstrom "Pica" = Pica (1/72 in.) Time units: "yr" = Year "day" = Day "hr" = Hour "mn" = Minute "sec" = Second Pressure units "Pa" (or "p") = Pascal "atm" (or "at") = Atmosphere "mmHg" = mm of Mercury Force units "N" = Newton "dyn" (or "dy") = Dyne "lbf" = Pound force Energy units: "J" = Joule "e" = Erg "c" = Thermodynamic calorie "cal" = IT calorie "eV" (or "ev") = Electron volt "HPh" (or "hh") = Horsepower-hour "Wh" (or "wh") = Watt-hour "flb" = Foot-pound "BTU" (or "btu") = BTU Power units: "HP" (or "h") = Horsepower "W" (or "w") = Watt Magentism units: "T" = Tesla "ga" = Gauss Temperature units: "C" (or "cel") = Degree Celsius "F" (or "fah") = Degree Fahrenheit "K" (or "kel") = Kelvin Liquid measure units: "tsp" = Teaspoon "tbs" = Tablespoon "oz" = Fluid ounce "cup" = Cup "pt" (or "us_pt") = U.S. pint "uk_pt" = U.K. pint "qt" = Quart "gal" = Gallon "l" (or "lt") = Liter Any metric unit may be prefixed with one of the following: exa ("E") = 1E+18 peta ("P") = 1E+15 tera ("T") = 1E+12 giga ("G") = 1E+09 mega ("M") = 1E+06 kilo ("k") = 1E+03 hecto ("h") = 1E+02 dekao ("e") = 1E+01 deci ("d") = 1E-01 centi ("c") = 1E-02 milli ("m") = 1E-03 micro ("u") = 1E-06 nano ("n") = 1E-09 pico ("p") = 1E-12 femto ("f") = 1E-15 atto ("a") = 1E-18

Func_convert_ArgDesc_2

ToUnit is the units to convert to. Weight and mass units: "g" = gram "sg" = slug "lbm" = pound mass (avoirdupois) "u" = U (atomic mass unit) "ozm" = Ounce mass (avoirdupois) Distance units: "m" = Meter "mi" = Statute mile "Nmi" = Nautical mile "in" = Inch "ft" = Foot "yd" = Yard "ang" = Angstrom "Pica" = Pica (1/72 in.) Time units: "yr" = Year "day" = Day "hr" = Hour "mn" = Minute "sec" = Second Pressure units "Pa" (or "p") = Pascal "atm" (or "at") = Atmosphere "mmHg" = mm of Mercury Force units "N" = Newton "dyn" (or "dy") = Dyne "lbf" = Pound force Energy units: "J" = Joule "e" = Erg "c" = Thermodynamic calorie "cal" = IT calorie "eV" (or "ev") = Electron volt "HPh" (or "hh") = Horsepower-hour "Wh" (or "wh") = Watt-hour "flb" = Foot-pound "BTU" (or "btu") = BTU Power units: "HP" (or "h") = Horsepower "W" (or "w") = Watt Magentism units: "T" = Tesla "ga" = Gauss Temperature units: "C" (or "cel") = Degree Celsius "F" (or "fah") = Degree Fahrenheit "K" (or "kel") = Kelvin Liquid measure units: "tsp" = Teaspoon "tbs" = Tablespoon "oz" = Fluid ounce "cup" = Cup "pt" (or "us_pt") = U.S. pint "uk_pt" = U.K. pint "qt" = Quart "gal" = Gallon "l" (or "lt") = Liter Any metric unit may be prefixed with one of the following: exa ("E") = 1E+18 peta ("P") = 1E+15 tera ("T") = 1E+12 giga ("G") = 1E+09 mega ("M") = 1E+06 kilo ("k") = 1E+03 hecto ("h") = 1E+02 dekao ("e") = 1E+01 deci ("d") = 1E-01 centi ("c") = 1E-02 milli ("m") = 1E-03 micro ("u") = 1E-06 nano ("n") = 1E-09 pico ("p") = 1E-12 femto ("f") = 1E-15 atto ("a") = 1E-18

Func_convert_Category

Engineering

Func_convert_CategoryURL

Engineering

Func_convert_Desc

Converts a value from one system of measurement to another. For example, meters to inches or hours to seconds.

Func_cos_Arg_0

number

Func_cos_ArgDesc_0

Number is the angle in radians for which you want the cosine

Func_cos_Category

Math

Func_cos_CategoryURL

Math

Func_cos_Desc

Returns the cosine of the given angle

Func_cosh_Arg_0

number

Func_cosh_ArgDesc_0

Number is any real number for which you want to find the hyperbolic cosine

Func_cosh_Category

Math

Func_cosh_CategoryURL

Math

Func_cosh_Desc

Returns the hyperbolic cosine of a number

Func_count_Arg_0

value{0}

Func_count_ArgDesc_0

Value1, value2, …​ valueN are arguments that can contain or refer to a variety of different types of data, but only numbers are counted

Func_count_Category

Statistical

Func_count_CategoryURL

Statistical

Func_count_Desc

Counts the number of cells that contain numbers and also numbers within the list of arguments

Func_date_Arg_0

year

Func_date_Arg_1

month

Func_date_Arg_2

day

Func_date_ArgDesc_0

Year is the number representing the year

Func_date_ArgDesc_1

Month is a number representing the month of the year

Func_date_ArgDesc_2

Day is a number representing the day of the month

Func_date_Category

DateAndTime

Func_date_CategoryURL

Date_and_Time

Func_date_Desc

Returns the sequential serial number that represents a particular date

Func_dateadd_Arg_0

interval

Func_dateadd_Arg_1

number

Func_dateadd_Arg_2

date

Func_dateadd_ArgDesc_0

String expression representing the time interval you want to add. d = Day y = Day h = Hour n = Minute m = Month q = Quarter s = Second w = Week ww = Calendar week yyyy = Year

Func_dateadd_ArgDesc_1

Value representing the number of intervals you want to add. This value can be positive (to get a DateTime in the future) or negative (to get a DateTime in the past). It can contain a fractional part when Interval specifies hours, minutes, or seconds. For other values of Interval, any fractional part of Number is ignored.

Func_dateadd_ArgDesc_2

The date to which the interval is to be added

Func_dateadd_Category

DateAndTime

Func_dateadd_CategoryURL

Date_and_Time

Func_dateadd_Desc

Returns a .Net DateTime to which the specified interval has been added

Func_datediff_Arg_0

interval

Func_datediff_Arg_1

date1

Func_datediff_Arg_2

date2

Func_datediff_ArgDesc_0

String expression representing the time interval you want to use as the unit of difference between date1 and date2. d = Day y = Day h = Hour n = Minute m = Month q = Quarter s = Second w = Week ww = Calendar week yyyy = Year

Func_datediff_ArgDesc_1

Date1 is subtracted from date2 to produce the difference.

Func_datediff_ArgDesc_2

The date from which date1 is subtracted to produce the difference.

Func_datediff_Category

DateAndTime

Func_datediff_CategoryURL

Date_and_Time

Func_datediff_Desc

Returns a value indicating the number of intervals between two DateTime values.

Func_datevalue_Arg_0

date_text

Func_datevalue_ArgDesc_0

Date_text is text that represents a date in a .NET DateTime format

Func_datevalue_Category

DateAndTime

Func_datevalue_CategoryURL

Date_and_Time

Func_datevalue_Desc

Returns the serial number of the date represented by date_text

Func_day_Arg_0

Date_value

Func_day_ArgDesc_0

Date_value is a .NET DateTime number that represents a particular date

Func_day_Category

DateAndTime

Func_day_CategoryURL

Date_and_Time

Func_day_Desc

Returns the day of a date value

Func_dayofweek_Arg_0

date

Func_dayofweek_Arg_1

returnType

Func_dayofweek_ArgDesc_0

Date is a date.

Func_dayofweek_ArgDesc_1

ReturnType determines which numbering scheme is used for the days of the week. 1 (default) = Sunday (1) through Saturday (7) 2 = Monday (1) through Sunday (7) 3 = Monday (0) through Sunday (6)

Func_dayofweek_Category

DateAndTime

Func_dayofweek_CategoryURL

DateAndTime

Func_dayofweek_Desc

Returns a number representing the day of the week of the specified date.

Func_days360_Arg_0

start_date

Func_days360_Arg_1

end_date

Func_days360_Arg_2

method

Func_days360_ArgDesc_0

Start_date and end_date are the two dates between which you want to know the number of days

Func_days360_ArgDesc_1

Start_date and end_date are the two dates between which you want to know the number of days

Func_days360_ArgDesc_2

Method is a logical value that specifies whether to use the U.S. (false) or European (true) method in the calculation

Func_days360_Category

DateAndTime

Func_days360_CategoryURL

Date_and_Time

Func_days360_Desc

Returns the number of days between two dates based on a 360-day year

Func_db_Arg_0

cost

Func_db_Arg_1

salvage

Func_db_Arg_2

life

Func_db_Arg_3

period

Func_db_Arg_4

month

Func_db_ArgDesc_0

Cost is the initial cost of the asset

Func_db_ArgDesc_1

Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset)

Func_db_ArgDesc_2

Life is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)

Func_db_ArgDesc_3

Period is the period for which you want to calculate the depreciation. Period must use the same units as life

Func_db_ArgDesc_4

Month is the number of months in the first year. If month is omitted, it is assumed to be 12

Func_db_Category

Financial

Func_db_CategoryURL

Financial

Func_db_Desc

Returns the depreciation of an asset for a specified period using the fixed-declining balance method

Func_dbnull_Category

Information

Func_dbnull_CategoryURL

Information

Func_dbnull_Desc

Returns DBNull.Value

Func_ddb_Arg_0

cost

Func_ddb_Arg_1

salvage

Func_ddb_Arg_2

life

Func_ddb_Arg_3

period

Func_ddb_Arg_4

factor

Func_ddb_ArgDesc_0

Cost is the initial cost of the asset

Func_ddb_ArgDesc_1

Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset)

Func_ddb_ArgDesc_2

Life is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)

Func_ddb_ArgDesc_3

Period is the period for which you want to calculate the depreciation. Period must use the same units as life

Func_ddb_ArgDesc_4

Factor is the rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method)

Func_ddb_Category

Financial

Func_ddb_CategoryURL

Financial

Func_ddb_Desc

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify

Func_dec2bin_Arg_0

Number

Func_dec2bin_Arg_1

Places

Func_dec2bin_ArgDesc_0

Number is the decimal value to be converted.

Func_dec2bin_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_dec2bin_Category

Engineering

Func_dec2bin_CategoryURL

Engineering

Func_dec2bin_Desc

Returns a string representing the specified decimal value as a binary number.

Func_dec2hex_Arg_0

Number

Func_dec2hex_Arg_1

Places

Func_dec2hex_ArgDesc_0

Number is the decimal value to be converted.

Func_dec2hex_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_dec2hex_Category

Engineering

Func_dec2hex_CategoryURL

Engineering

Func_dec2hex_Desc

Returns a string representing the specified decimal value as a hexadecimal number.

Func_dec2oct_Arg_0

Number

Func_dec2oct_Arg_1

Places

Func_dec2oct_ArgDesc_0

Number is the decimal value to be converted.

Func_dec2oct_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_dec2oct_Category

Engineering

Func_dec2oct_CategoryURL

Engineering

Func_dec2oct_Desc

Returns a string representing the specified decimal value as a octal number.

Func_degrees_Arg_0

Radians

Func_degrees_ArgDesc_0

Radians is a value in radians which will be converted to degrees.

Func_degrees_Category

Math

Func_degrees_CategoryURL

Math

Func_degrees_Desc

Converts radians to degrees.

Func_delta_Arg_0

Number1

Func_delta_Arg_1

Number2

Func_delta_ArgDesc_0

Number1 is a number.

Func_delta_ArgDesc_1

Number2 is a number. If Number2 is not specified, Number1 will be compared to 0.

Func_delta_Category

Engineering

Func_delta_CategoryURL

Engineering

Func_delta_Desc

Compares two numbers and returns 1 if they are equal or 0 if they are not.

Func_dollarde_Arg_0

FractionDollarAmount

Func_dollarde_Arg_1

Fraction

Func_dollarde_ArgDesc_0

FractionDollarAmount is the dollar amount expressed as a fraction.

Func_dollarde_ArgDesc_1

Fraction is the value used as the denominator of the fraction. If this value is not an integer, it will be truncated.

Func_dollarde_Category

Financial

Func_dollarde_CategoryURL

Financial

Func_dollarde_Desc

Converts a dollar amount expressed as a fraction into a dollar amount expressed as a decimal.

Func_dollarfr_Arg_0

DecimalDollarAmount

Func_dollarfr_Arg_1

Fraction

Func_dollarfr_ArgDesc_0

DecimalDollarAmount is the dollar amount expressed as a decimal.

Func_dollarfr_ArgDesc_1

Fraction is the value used as the denominator of the fraction. If this value is not an integer, it will be truncated.

Func_dollarfr_Category

Financial

Func_dollarfr_CategoryURL

Financial

Func_dollarfr_Desc

Converts a dollar amount expressed as a decimal into a dollar amount expressed as a fraction.

Func_edate_Arg_0

date

Func_edate_Arg_1

numberOfMonths

Func_edate_ArgDesc_0

Date is the starting date

Func_edate_ArgDesc_1

NumberOfMonths is a number of months to shift the date. A positive number means a date after the startdate. A negative number indicates a date prior to the start date.

Func_edate_Category

DateAndTime

Func_edate_CategoryURL

DateAndTime

Func_edate_Desc

Returns a date that is the specified number of months before or after the start date.

Func_eomonth_Arg_0

date

Func_eomonth_Arg_1

numberOfMonths

Func_eomonth_ArgDesc_0

Date is the starting date

Func_eomonth_ArgDesc_1

NumberOfMonths is a number of months to shift the date. A positive number means a date after the startdate. A negative number indicates a date prior to the start date.

Func_eomonth_Category

DateAndTime

Func_eomonth_CategoryURL

DateAndTime

Func_eomonth_Desc

Returns a date that is at the end of the month which is the specified number of months before or after the start date.

Func_errortype_Arg_0

error_value

Func_errortype_ArgDesc_0

Error_val is the error value whose identifying number you want to find

Func_errortype_Category

Information

Func_errortype_CategoryURL

Information

Func_errortype_Desc

Returns the type of error value

Func_even_Arg_0

number

Func_even_ArgDesc_0

Number is the value to round

Func_even_Category

Math

Func_even_CategoryURL

Math

Func_even_Desc

Rounds a positive number up and a negative number down to nearest even integer.

Func_exp_Arg_0

number

Func_exp_ArgDesc_0

Number is the exponent applied to the base e

Func_exp_Category

Math

Func_exp_CategoryURL

Math

Func_exp_Desc

Returns e raised to the power of number. The constant e equals 2.71828182845904

Func_fact_Arg_0

Number

Func_fact_ArgDesc_0

Number is a positive number for which the factorial will be calculated.

Func_fact_Category

Math

Func_fact_CategoryURL

Math

Func_fact_Desc

Returns the factorial of a number.

Func_factdouble_Arg_0

Number

Func_factdouble_ArgDesc_0

Number is a positive number for which the double factorial will be calculated.

Func_factdouble_Category

Math

Func_factdouble_CategoryURL

Math

Func_factdouble_Desc

Returns the double factorial of a number.

Func_false_Category

Logical

Func_false_CategoryURL

Logical

Func_false_Desc

Returns the logical value FALSE

Func_find_Arg_0

find_text

Func_find_Arg_1

within_text

Func_find_Arg_2

start_num

Func_find_ArgDesc_0

Find_text is the text you want to find

Func_find_ArgDesc_1

Within_text is the text containing the text you want to find

Func_find_ArgDesc_2

Start_num specifies the character at which to start the search. 1 is assumed if Start_num is omitted.

Func_find_Category

TextAndData

Func_find_CategoryURL

Text_and_Data

Func_find_Desc

FIND finds one text string

Func_fixed_Arg_0

number

Func_fixed_Arg_1

decimals

Func_fixed_Arg_2

no_commas

Func_fixed_ArgDesc_0

The number you want to round and convert to text.

Func_fixed_ArgDesc_1

The number of digits to the right of the decimal point in the return value. If this value is negative, 'number' is rounded to the left of the decimal point. The default value is 2.

Func_fixed_ArgDesc_2

Pass TRUE if commas should not be in the return value. If commas should appear in the return value then you can pass FALSE or simply omit this argument.

Func_fixed_Category

TextAndData

Func_fixed_CategoryURL

Text_and_Data

Func_fixed_Desc

Rounds a number to the specified number of decimals and returns the result as text with or without commas.

Func_floor_Arg_0

number

Func_floor_Arg_1

significance

Func_floor_ArgDesc_0

Number is the numeric value you want to round

Func_floor_Category

Math

Func_floor_CategoryURL

Math

Func_floor_Desc

Returns the smallest multiple of the significance (defaults to 1) less than or equal to the given number.

Func_fv_Arg_0

rate

Func_fv_Arg_1

nper

Func_fv_Arg_2

pmt

Func_fv_Arg_3

pv

Func_fv_Arg_4

type

Func_fv_ArgDesc_0

Rate is the interest rate per period

Func_fv_ArgDesc_1

Nper is the total number of payment periods in an annuity

Func_fv_ArgDesc_2

Pmt is the payment made each period; it cannot change over the life of the annuity

Func_fv_ArgDesc_3

Pv is the present value, or the lump-sum amount that a series of future payments is worth right now

Func_fv_ArgDesc_4

Type is the number 0 or 1 and indicates whether payments are due at the end of the period (default) or the beginning

Func_fv_Category

Financial

Func_fv_CategoryURL

Financial

Func_fv_Desc

Returns the future value of an investment based on periodic

Func_gcd_Arg_0

number{0}

Func_gcd_ArgDesc_0

Number1, Number2, …​, NumberN is any number of integers.

Func_gcd_Category

Math

Func_gcd_CategoryURL

Math

Func_gcd_Desc

Returns the greatest common divisor of two integer values.

Func_gestep_Arg_0

Number1

Func_gestep_Arg_1

Step

Func_gestep_ArgDesc_0

Number is a number.

Func_gestep_ArgDesc_1

Step is a number. If step is not specified, Number will be compared to 0.

Func_gestep_Category

Engineering

Func_gestep_CategoryURL

Engineering

Func_gestep_Desc

Compares two numbers and returns 1 the first number is greater than or equal to the second or returns 0 if not.

Func_hex2bin_Arg_0

Number

Func_hex2bin_Arg_1

Places

Func_hex2bin_ArgDesc_0

Number is the value to be converted.

Func_hex2bin_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_hex2bin_Category

Engineering

Func_hex2bin_CategoryURL

Engineering

Func_hex2bin_Desc

Converts a string representing a hexadecimal number to a string representing the same number in the binary number system.

Func_hex2dec_Arg_0

Number

Func_hex2dec_ArgDesc_0

Number is a string represeting a hexadecimal number.

Func_hex2dec_Category

Engineering

Func_hex2dec_CategoryURL

Engineering

Func_hex2dec_Desc

Returns the decimal value of a string representation of a number in a hexadecimal system.

Func_hex2oct_Arg_0

Number

Func_hex2oct_Arg_1

Places

Func_hex2oct_ArgDesc_0

Number is the value to be converted.

Func_hex2oct_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_hex2oct_Category

Engineering

Func_hex2oct_CategoryURL

Engineering

Func_hex2oct_Desc

Converts a string representing a hexadecimal number to a string representing the same number in the octal number system.

Func_hour_Arg_0

Date_value

Func_hour_ArgDesc_0

Date_value is a .NET DateTime number that represents a particular date

Func_hour_Category

DateAndTime

Func_hour_CategoryURL

Date_and_Time

Func_hour_Desc

Returns the hour of a time value

Func_if_Arg_0

logical_test

Func_if_Arg_1

value_if_true

Func_if_Arg_2

value_if_false

Func_if_ArgDesc_0

The condition to test.

Func_if_ArgDesc_1

The result if the condition is true.

Func_if_ArgDesc_2

The result if the condition is false.

Func_if_Category

Logical

Func_if_CategoryURL

Logical

Func_if_Desc

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE

Func_imabs_Arg_0

ComplexNumber

Func_imabs_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imabs_Category

Engineering

Func_imabs_CategoryURL

Engineering

Func_imabs_Desc

Returns the absolute value of a complex number.

Func_imaginary_Arg_0

ComplexNumber

Func_imaginary_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imaginary_Category

Engineering

Func_imaginary_CategoryURL

Engineering

Func_imaginary_Desc

Returns the imaginary coefficient of a complex number.

Func_imargument_Arg_0

ComplexNumber

Func_imargument_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imargument_Category

Engineering

Func_imargument_CategoryURL

Engineering

Func_imargument_Desc

Returns the argument theta, and angle expressed in radians.

Func_imconjugate_Arg_0

ComplexNumber

Func_imconjugate_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imconjugate_Category

Engineering

Func_imconjugate_CategoryURL

Engineering

Func_imconjugate_Desc

Returns the conjugate of a complex number.

Func_imcos_Arg_0

ComplexNumber

Func_imcos_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imcos_Category

Engineering

Func_imcos_CategoryURL

Engineering

Func_imcos_Desc

Returns the cosine of a complex number.

Func_imdiv_Arg_0

Dividend

Func_imdiv_Arg_1

Divisor

Func_imdiv_ArgDesc_0

Dividend is a complex number in the format: "x + yi" or "x + yj".

Func_imdiv_ArgDesc_1

Divisor is a complex number in the format: "x + yi" or "x + yj".

Func_imdiv_Category

Engineering

Func_imdiv_CategoryURL

Engineering

Func_imdiv_Desc

Returns the quotient of two complex numbers. (Dividend / Divisor)

Func_imexp_Arg_0

ComplexNumber

Func_imexp_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imexp_Category

Engineering

Func_imexp_CategoryURL

Engineering

Func_imexp_Desc

Returns the exponential of a complex number.

Func_imln_Arg_0

ComplexNumber

Func_imln_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imln_Category

Engineering

Func_imln_CategoryURL

Engineering

Func_imln_Desc

Returns the natural logarithm of a complex number.

Func_imlog10_Arg_0

ComplexNumber

Func_imlog10_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imlog10_Category

Engineering

Func_imlog10_CategoryURL

Engineering

Func_imlog10_Desc

Returns the base-10 logarithm of a complex number.

Func_imlog2_Arg_0

ComplexNumber

Func_imlog2_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imlog2_Category

Engineering

Func_imlog2_CategoryURL

Engineering

Func_imlog2_Desc

Returns the base-2 logarithm of a complex number.

Func_impower_Arg_0

ComplexNumber

Func_impower_Arg_1

Power

Func_impower_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_impower_ArgDesc_1

Power is the power to which ComplexNumber will be raised.

Func_impower_Category

Engineering

Func_impower_CategoryURL

Engineering

Func_impower_Desc

Returns the complex number raised to the specified power.

Func_improduct_Arg_0

ComplexNumber{0}

Func_improduct_ArgDesc_0

ComplexNumber1, ComplexNumber2, …​, ComplexNumberN is any number of complex numbers in the format: "x + yi" or "x + yj" which will be multiplied together.

Func_improduct_Category

Engineering

Func_improduct_CategoryURL

Engineering

Func_improduct_Desc

Returns the product of 1 to n complex numbers.

Func_imreal_Arg_0

ComplexNumber

Func_imreal_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imreal_Category

Engineering

Func_imreal_CategoryURL

Engineering

Func_imreal_Desc

Returns the real coefficient of a complex number.

Func_imsin_Arg_0

ComplexNumber

Func_imsin_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imsin_Category

Engineering

Func_imsin_CategoryURL

Engineering

Func_imsin_Desc

Returns the sine of a complex number.

Func_imsqrt_Arg_0

ComplexNumber

Func_imsqrt_ArgDesc_0

ComplexNumber is a complex number in the format: "x + yi" or "x + yj".

Func_imsqrt_Category

Engineering

Func_imsqrt_CategoryURL

Engineering

Func_imsqrt_Desc

Returns the square root of a complex number.

Func_imsub_Arg_0

ComplexNumber1

Func_imsub_Arg_1

ComplexNumber2

Func_imsub_ArgDesc_0

ComplexNumber1 is a complex number in the format: "x + yi" or "x + yj" from which ComplexNumber2 will be subtracted.

Func_imsub_ArgDesc_1

ComplexNumber2 is a complex number in the format: "x + yi" or "x + yj" which will be subtracted from ComplexNumber1.

Func_imsub_Category

Engineering

Func_imsub_CategoryURL

Engineering

Func_imsub_Desc

Returns the difference between two complex numbers.

Func_imsum_Arg_0

ComplexNumber{0}

Func_imsum_ArgDesc_0

ComplexNumber1, ComplexNumber2, …​, ComplexNumberN is any number of complex numbers in the format: "x + yi" or "x + yj" which will be added together.

Func_imsum_Category

Engineering

Func_imsum_CategoryURL

Engineering

Func_imsum_Desc

Returns the sum of 1 to n complex numbers.

Func_info_Arg_0

Type

Func_info_ArgDesc_0

Type is a string indicating the type of information to return. "directory" = The full path to the current folder. "osversion" = The currently operating system version as a string. "system" = The current operating system. This will always return "pcdos" which indicates Microsoft Windows. The corresponding function in Excel can also return "mac" for Macintosh, but since Infragistics is only supported in Windows, this function will always return "pcdos". The following are supported by Microsoft Excel, but have no correlation in UltraCalcManager: "numfile", "origin", "recalc", "release". The following are supported in older versions of Excel, but not Office2007, and have no correlation in UltraCalcManager: "memavail", "memused", "totmem".

Func_info_Category

Information

Func_info_CategoryURL

Information

Func_info_Desc

Returns information about the current operating environment.

Func_int_Arg_0

number

Func_int_ArgDesc_0

Number is the real number you want to round down to an integer

Func_int_Category

Math

Func_int_CategoryURL

Math

Func_int_Desc

Rounds a number down to the nearest integer

Func_intrate_Arg_0

settlement

Func_intrate_Arg_1

maturity

Func_intrate_Arg_2

investment

Func_intrate_Arg_3

redemption

Func_intrate_Arg_4

basis

Func_intrate_ArgDesc_0

Settlement is the security’s settlement date

Func_intrate_ArgDesc_1

Maturity is the security’s maturity date

Func_intrate_ArgDesc_2

Investment is the amount invested in the security

Func_intrate_ArgDesc_3

Redemption is the amount to be received at maturity

Func_intrate_ArgDesc_4

Basis is the type of day count basis to use; 0 or omitted = US (NASD) 30/360, 1 = Actual/actual, 2 = Actual/360, 3 = Actual/365, 4 = European 30/360

Func_intrate_Category

Financial

Func_intrate_CategoryURL

Financial

Func_intrate_Desc

Returns the interest rate for a fully invested security

Func_ipmt_Arg_0

rate

Func_ipmt_Arg_1

per

Func_ipmt_Arg_2

nper

Func_ipmt_Arg_3

pv

Func_ipmt_Arg_4

fv

Func_ipmt_Arg_5

type

Func_ipmt_ArgDesc_0

Rate is the interest rate per period

Func_ipmt_ArgDesc_1

Per specifies the period and must be in the range 1 to nper

Func_ipmt_ArgDesc_2

Nper is the total number of payment periods in an annuity

Func_ipmt_ArgDesc_3

Pv is the present value, the total amount that a series of future payments is worth now

Func_ipmt_ArgDesc_4

Fv is the future value, or a cash balance you want to attain after the last payment is made

Func_ipmt_ArgDesc_5

Type is the number 0 or 1 and indicates when payments are due

Func_ipmt_Category

Financial

Func_ipmt_CategoryURL

Financial

Func_ipmt_Desc

Returns the interest payment for a given period for an investment based on periodic

Func_irr_Arg_0

values

Func_irr_Arg_1

guess

Func_irr_ArgDesc_0

A collection of payment (negative values) and income (positive values) values that occur at regular intervals

Func_irr_ArgDesc_1

An optional number that you guess is close to the result. The default is 10%.

Func_irr_Category

Financial

Func_irr_CategoryURL

Financial

Func_irr_Desc

Returns the internal rate of return for a series of cash flows

Func_isblank_Arg_0

value

Func_isblank_ArgDesc_0

Value is the value you want tested

Func_isblank_Category

Information

Func_isblank_CategoryURL

Information

Func_isblank_Desc

Returns TRUE if value is blank

Func_isdbnull_Arg_0

value

Func_isdbnull_ArgDesc_0

Value is the value you want tested

Func_isdbnull_Category

Information

Func_isdbnull_CategoryURL

Information

Func_isdbnull_Desc

Returns TRUE if value refers to DBNull

Func_iserr_Arg_0

value

Func_iserr_ArgDesc_0

Value is the value you want tested

Func_iserr_Category

Information

Func_iserr_CategoryURL

Information

Func_iserr_Desc

Returns TRUE if value refers to any error value except #N/A

Func_iserror_Arg_0

value

Func_iserror_ArgDesc_0

Value is the value you want tested

Func_iserror_Category

Information

Func_iserror_CategoryURL

Information

Func_iserror_Desc

Returns TRUE if value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!)

Func_iseven_Arg_0

value

Func_iseven_ArgDesc_0

Value is the value you want tested

Func_iseven_Category

Information

Func_iseven_CategoryURL

Information

Func_iseven_Desc

Returns TRUE if value is an even number, else return false

Func_islogical_Arg_0

value

Func_islogical_ArgDesc_0

Value is the value you want tested

Func_islogical_Category

Information

Func_islogical_CategoryURL

Information

Func_islogical_Desc

Returns TRUE if value refers to a logical value

Func_isna_Arg_0

value

Func_isna_ArgDesc_0

Value is the value you want tested

Func_isna_Category

Information

Func_isna_CategoryURL

Information

Func_isna_Desc

Returns TRUE if value refers to the #N/A (value not available) error value

Func_isnontext_Arg_0

value

Func_isnontext_ArgDesc_0

Value is the value you want tested

Func_isnontext_Category

Information

Func_isnontext_CategoryURL

Information

Func_isnontext_Desc

Returns TRUE if value refers to any item that is not text

Func_isnull_Arg_0

value

Func_isnull_ArgDesc_0

Value is the value you want tested

Func_isnull_Category

Information

Func_isnull_CategoryURL

Information

Func_isnull_Desc

Returns TRUE if value refers to null (Nothing in VB)

Func_isnumber_Arg_0

value

Func_isnumber_ArgDesc_0

Value is the value you want tested

Func_isnumber_Category

Information

Func_isnumber_CategoryURL

Information

Func_isnumber_Desc

Returns TRUE if value refers to a number

Func_isodd_Arg_0

value

Func_isodd_ArgDesc_0

Value is the value you want tested

Func_isodd_Category

Information

Func_isodd_CategoryURL

Information

Func_isodd_Desc

Returns TRUE if value is an odd number, else return false

Func_isref_Arg_0

value

Func_isref_ArgDesc_0

Value is the value you want tested

Func_isref_Category

Information

Func_isref_CategoryURL

Information

Func_isref_Desc

Returns TRUE if value refers to a reference

Func_istext_Arg_0

value

Func_istext_ArgDesc_0

Value is the value you want tested

Func_istext_Category

Information

Func_istext_CategoryURL

Information

Func_istext_Desc

Returns TRUE if value refers to a text value

Func_lcm_Arg_0

number{0}

Func_lcm_ArgDesc_0

Number1, Number2, …​, NumberN is any number of integers.

Func_lcm_Category

Math

Func_lcm_CategoryURL

Math

Func_lcm_Desc

Returns the least common multiple of integer values.

Func_left_Arg_0

text

Func_left_Arg_1

num_chars

Func_left_ArgDesc_0

Text is the text string that contains the characters you want to extract

Func_left_ArgDesc_1

Num_chars specifies the number of characters you want LEFT to extract

Func_left_Category

TextAndData

Func_left_CategoryURL

Text_and_Data

Func_left_Desc

LEFT returns the first character or characters in a text string

Func_len_Arg_0

text

Func_len_ArgDesc_0

Text is the text whose length you want to find. Spaces count as characters

Func_len_Category

TextAndData

Func_len_CategoryURL

Text_and_Data

Func_len_Desc

Returns the number of characters in a text string

Func_ln_Arg_0

number

Func_ln_ArgDesc_0

Number is the positive real number for which you want the natural logarithm

Func_ln_Category

Math

Func_ln_CategoryURL

Math

Func_ln_Desc

Returns the natural logarithm of a number

Func_log_Arg_0

number

Func_log_Arg_1

base

Func_log_ArgDesc_0

Number is the positive real number for which you want the logarithm

Func_log_ArgDesc_1

Base is the base of the logarithm. If base is omitted, it is assumed to be 10

Func_log_Category

Math

Func_log_CategoryURL

Math

Func_log_Desc

Returns the logarithm of a number to the base you specify

Func_log10_Arg_0

number

Func_log10_ArgDesc_0

Number is the positive real number for which you want the base-10 logarithm

Func_log10_Category

Math

Func_log10_CategoryURL

Math

Func_log10_Desc

Returns the base-10 logarithm of a number

Func_lower_Arg_0

text

Func_lower_ArgDesc_0

Text is the text you want to convert to lowercase

Func_lower_Category

TextAndData

Func_lower_CategoryURL

Text_and_Data

Func_lower_Desc

Converts all uppercase letters in a text string to lowercase

Func_max_Arg_0

number{0}

Func_max_ArgDesc_0

Number1, number2, …​ are 1 to 30 numbers for which you want to find the maximum value

Func_max_Category

Statistical

Func_max_CategoryURL

Statistical

Func_max_Desc

Returns the largest number in a set of values

Func_median_Arg_0

number{0}

Func_median_ArgDesc_0

Number1, number2, …​ are 1 to 30 numbers for which you want to find the median value

Func_median_Category

Statistical

Func_median_CategoryURL

Statistical

Func_median_Desc

Returns the median of a set of values

Func_mid_Arg_0

text

Func_mid_Arg_1

start_num

Func_mid_Arg_2

num_chars

Func_mid_ArgDesc_0

Text is the text string that contains the characters you want to extract

Func_mid_ArgDesc_1

Num_chars specifies the number of characters you want LEFT to extract

Func_mid_ArgDesc_2

Start_num is the position of the first character you want to extract in text

Func_mid_Category

TextAndData

Func_mid_CategoryURL

Text_and_Data

Func_mid_Desc

MID returns a specific number of characters from a text string

Func_min_Arg_0

number{0}

Func_min_ArgDesc_0

Number1, number2, …​ are 1 to 30 numbers for which you want to find the minimum value

Func_min_Category

Statistical

Func_min_CategoryURL

Statistical

Func_min_Desc

Returns the smallest number in a set of values

Func_minute_Arg_0

Date_value

Func_minute_ArgDesc_0

Date_value is a .NET DateTime number that represents a particular date

Func_minute_Category

DateAndTime

Func_minute_CategoryURL

Date_and_Time

Func_minute_Desc

Returns the minute of a time value

Func_mod_Arg_0

number

Func_mod_Arg_1

divisor

Func_mod_ArgDesc_0

Number is the number for which you want to find the remainder

Func_mod_ArgDesc_1

Divisor is the number by which you want to divide number

Func_mod_Category

Math

Func_mod_CategoryURL

Math

Func_mod_Desc

Returns the remainder after number is divided by divisor. The result has the same sign as divisor

Func_month_Arg_0

Date_value

Func_month_ArgDesc_0

Date_value is a .NET DateTime number that represents a particular date

Func_month_Category

DateAndTime

Func_month_CategoryURL

Date_and_Time

Func_month_Desc

Returns the month of a date value

Func_mround_Arg_0

Number

Func_mround_Arg_1

Multiple

Func_mround_ArgDesc_0

Number is a number to be rounded.

Func_mround_ArgDesc_1

Multiple is a number indicating the multiple to which to round.

Func_mround_Category

Math

Func_mround_CategoryURL

Math

Func_mround_Desc

Rounds a number to the nearest multiple of another number.

Func_multinomial_Arg_0

number{0}

Func_multinomial_ArgDesc_0

Number1, Number2, …​, NumberN is any number of numbers.

Func_multinomial_Category

Math

Func_multinomial_CategoryURL

Math

Func_multinomial_Desc

Returns the multinomial of a set of numbers.

Func_n_Arg_0

Value

Func_n_ArgDesc_0

Value is the value to be converted to a number. The following are acceptable values: A number - returns the number. A date - returns the date. True - returns 1. False - returns 0. An error value - returns the error value. Any other value - returns 0\.

Func_n_Category

Information

Func_n_CategoryURL

Information

Func_n_Desc

Converts a value to a number.

Func_na_Category

Information

Func_na_CategoryURL

Information

Func_na_Desc

Returns the error value #N/A

Func_networkdays_Arg_0

startDate

Func_networkdays_Arg_1

endDate

Func_networkdays_Arg_2

holiday{0}

Func_networkdays_ArgDesc_0

StartDate is the date from which to start.

Func_networkdays_ArgDesc_1

EndDate is the date at which to end.

Func_networkdays_ArgDesc_2

Holiday1, holiday2, …​, holidayN is any number of dates or range references containing dates that are to be considered non-working days.

Func_networkdays_Category

DateAndTime

Func_networkdays_CategoryURL

DateAndTime

Func_networkdays_Desc

Returns the total number of whole work days between the specified dates, excluding any specified holidays.

Func_not_Arg_0

logical

Func_not_ArgDesc_0

Logical is a value or expression that can be evaluated to TRUE or FALSE

Func_not_Category

Logical

Func_not_CategoryURL

Logical

Func_not_Desc

Reverses the logic of its argument

Func_now_Category

DateAndTime

Func_now_CategoryURL

Date_and_Time

Func_now_Desc

Returns a .NET DateTime ticks value of the current day and time

Func_nper_Arg_0

rate

Func_nper_Arg_1

pmt

Func_nper_Arg_2

pv

Func_nper_Arg_3

fv

Func_nper_Arg_4

type

Func_nper_ArgDesc_0

Rate is the interest rate per period

Func_nper_ArgDesc_1

Pmt is the payment made each period; it cannot change over the life of the annuity

Func_nper_ArgDesc_2

Pv is the present value, or the lump-sum amount that a series of future payments is worth right now

Func_nper_ArgDesc_3

Fv is the future value, or a cash balance you want to attain after the last payment is made

Func_nper_ArgDesc_4

Type is the number 0 or 1 and indicates whether payments are due at the end of the period (default) or the beginning

Func_nper_Category

Financial

Func_nper_CategoryURL

Financial

Func_nper_Desc

Returns the number of periods for an investment based on periodic

Func_npv_Arg_0

rate

Func_npv_Arg_1

value{0}

Func_npv_ArgDesc_0

Rate is the rate of discount over the length of one period

Func_npv_ArgDesc_1

Value1, value2, …​ are 1 to 29 arguments representing the payments and income

Func_npv_Category

Financial

Func_npv_CategoryURL

Financial

Func_npv_Desc

Calculates the net present value of an investment by using a discount rate and a series of future payments

Func_null_Category

Information

Func_null_CategoryURL

Information

Func_null_Desc

Returns null (Nothing in VB)

Func_oct2bin_Arg_0

Number

Func_oct2bin_Arg_1

Places

Func_oct2bin_ArgDesc_0

Number is the value to be converted.

Func_oct2bin_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_oct2bin_Category

Engineering

Func_oct2bin_CategoryURL

Engineering

Func_oct2bin_Desc

Converts a string representing an octal number to a string representing the same number in the binary number system.

Func_oct2dec_Arg_0

Number

Func_oct2dec_ArgDesc_0

Number is a string represeting an octal number.

Func_oct2dec_Category

Engineering

Func_oct2dec_CategoryURL

Engineering

Func_oct2dec_Desc

Returns the decimal value of a string representation of a number in a octal system.

Func_oct2hex_Arg_0

Number

Func_oct2hex_Arg_1

Places

Func_oct2hex_ArgDesc_0

Number is the value to be converted.

Func_oct2hex_ArgDesc_1

Places is the number of characters to use in representing the value. If places is not specified, the mimumum number of characters neccessary to represent the value will be used. Places allows you to specify leading zeros.

Func_oct2hex_Category

Engineering

Func_oct2hex_CategoryURL

Engineering

Func_oct2hex_Desc

Converts a string representing an octal number to a string representing the same number in the hexadecimal number system.

Func_odd_Arg_0

number

Func_odd_ArgDesc_0

Number is the value to round

Func_odd_Category

Math

Func_odd_CategoryURL

Math

Func_odd_Desc

Rounds a positive number up and a negative number down to the nearest odd integer.

Func_or_Arg_0

logical{0}

Func_or_ArgDesc_0

Logical1, logical2, …​ are conditions you want to test that can be either TRUE or FALSE

Func_or_Category

Logical

Func_or_CategoryURL

Logical

Func_or_Desc

Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE

Func_pi_Category

Math

Func_pi_CategoryURL

Math

Func_pi_Desc

Returns the number 3.14159265358979

Func_pmt_Arg_0

rate

Func_pmt_Arg_1

nper

Func_pmt_Arg_2

pv

Func_pmt_Arg_3

fv

Func_pmt_Arg_4

type

Func_pmt_ArgDesc_0

Rate is the interest rate for the loan

Func_pmt_ArgDesc_1

Nper is the total number of payments for the loan

Func_pmt_ArgDesc_2

Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal

Func_pmt_ArgDesc_3

Fv is the future value, or a cash balance you want to attain after the last payment is made

Func_pmt_ArgDesc_4

Type is the number 0 or 1 and indicates whether payments are due at the end of the period (default) or the beginning

Func_pmt_Category

Financial

Func_pmt_CategoryURL

Financial

Func_pmt_Desc

Calculates the payment for a loan based on constant payments and a constant interest rate

Func_power_Arg_0

number

Func_power_Arg_1

power

Func_power_ArgDesc_0

Number is the base number

Func_power_ArgDesc_1

Power is the exponent to which the base number is raised

Func_power_Category

Math

Func_power_CategoryURL

Math

Func_power_Desc

Returns the result of a number raised to a power

Func_ppmt_Arg_0

rate

Func_ppmt_Arg_1

per

Func_ppmt_Arg_2

nper

Func_ppmt_Arg_3

pv

Func_ppmt_Arg_4

fv

Func_ppmt_Arg_5

type

Func_ppmt_ArgDesc_0

Rate is the interest rate per period

Func_ppmt_ArgDesc_1

Per specifies the period and must be in the range 1 to nper

Func_ppmt_ArgDesc_2

Nper is the total number of payment periods in an annuity

Func_ppmt_ArgDesc_3

Pv is the present value, the total amount that a series of future payments is worth now

Func_ppmt_ArgDesc_4

Fv is the future value, or a cash balance you want to attain after the last payment is made

Func_ppmt_ArgDesc_5

Type is the number 0 or 1 and indicates when payments are due

Func_ppmt_Category

Financial

Func_ppmt_CategoryURL

Financial

Func_ppmt_Desc

Returns the payment on the principal for a given period for an investment based on periodic

Func_product_Arg_0

number{0}

Func_product_ArgDesc_0

Number1, number2, …​ are arguments for which you want the to multiply together

Func_product_Category

Math

Func_product_CategoryURL

Math

Func_product_Desc

Multiplies all the numbers given as arguments and returns the product

Func_pv_Arg_0

rate

Func_pv_Arg_1

nper

Func_pv_Arg_2

pmt

Func_pv_Arg_3

fv

Func_pv_Arg_4

type

Func_pv_ArgDesc_0

Rate is the interest rate per period

Func_pv_ArgDesc_1

Nper is the total number of payment periods in an annuity

Func_pv_ArgDesc_2

Pmt is the payment made each period; it cannot change over the life of the annuity

Func_pv_ArgDesc_3

Fv is the future value, or a cash balance you want to attain after the last payment is made

Func_pv_ArgDesc_4

Type is the number 0 or 1 and indicates whether payments are due at the end of the period (default) or the beginning

Func_pv_Category

Financial

Func_pv_CategoryURL

Financial

Func_pv_Desc

Returns the present value of an investment

Func_quotient_Arg_0

numerator

Func_quotient_Arg_1

denominator

Func_quotient_ArgDesc_0

Numerator is the dividend

Func_quotient_ArgDesc_1

Denominator is the divisor

Func_quotient_Category

Math

Func_quotient_CategoryURL

Math

Func_quotient_Desc

Returns the integer portion of a division. Use this function when you want to discard the remainder of a division

Func_radians_Arg_0

Degrees

Func_radians_ArgDesc_0

Degrees is a value in degrees which will be converted to radians.

Func_radians_Category

Math

Func_radians_CategoryURL

Math

Func_radians_Desc

Converts degrees to radians.

Func_rand_Category

Math

Func_rand_CategoryURL

Math

Func_rand_Desc

Returns an evenly distributed random number greater than or equal to 0 and less than 1

Func_randbetween_Arg_0

Bottom

Func_randbetween_Arg_1

Top

Func_randbetween_ArgDesc_0

Bottom is the minumum value that will be returned.

Func_randbetween_ArgDesc_1

Top is the maximum value that will be returned.

Func_randbetween_Category

Math

Func_randbetween_CategoryURL

Math

Func_randbetween_Desc

Generates a pseudorandom integer between two specified numbers.

Func_rate_Arg_0

NPer

Func_rate_Arg_1

Pmt

Func_rate_Arg_2

Pv

Func_rate_Arg_3

Type

Func_rate_Arg_4

Fv

Func_rate_Arg_5

Guess

Func_rate_ArgDesc_0

Nper is the total number of payment periods in an annuity.

Func_rate_ArgDesc_1

Pmt is the payment made each period and cannot change over the life of the annuity.

Func_rate_ArgDesc_2

The present value - the total amount that a series of future payments is worth now.

Func_rate_ArgDesc_3

The number 0 or 1 that indicates whether payments are due at the end of the period (default) or the beginning.

Func_rate_ArgDesc_4

The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). For example, if you want to save $50,000 to pay for a special project in 18 years, then $50,000 is the future value. You could then make a conservative guess at an interest rate and determine how much you must save each month. If fv is omitted, you must include the pmt argument. The default value for fv is 0.

Func_rate_ArgDesc_5

An optional number that you guess is close to the result. If guess is unspecified, 10% is used.

Func_rate_Category

Financial

Func_rate_CategoryURL

Financial

Func_rate_Desc

Returns the interest rate per period of an annuity

Func_replace_Arg_0

Old_text

Func_replace_Arg_1

Start_num

Func_replace_Arg_2

Num_chars

Func_replace_Arg_3

New_text

Func_replace_ArgDesc_0

Old_text is text in which you want to replace some characters

Func_replace_ArgDesc_1

Start_num is the position of the character in old_text that you want to replace with new_text; 1 is the index of the first character

Func_replace_ArgDesc_2

Num_chars is the number of characters in old_text that you want REPLACE to replace with new_text

Func_replace_ArgDesc_3

New_text is the text that will replace characters in old_text

Func_replace_Category

TextAndData

Func_replace_CategoryURL

Text_and_Data

Func_replace_Desc

Replaces part of a text string

Func_right_Arg_0

text

Func_right_Arg_1

num_chars

Func_right_ArgDesc_0

Text is the text string that contains the characters you want to extract

Func_right_ArgDesc_1

Num_chars specifies the number of characters you want RIGHT to extract

Func_right_Category

TextAndData

Func_right_CategoryURL

Text_and_Data

Func_right_Desc

RIGHT returns the last character or characters in a text string

Func_roman_Arg_0

Number

Func_roman_Arg_1

Form

Func_roman_ArgDesc_0

Number is the number to convert to roman numerals.

Func_roman_ArgDesc_1

Form is a number or boolean value indicating whether to use classic roman numerals or a more concise version. 0 = (Default) Classic. (499 = "CDXCIX") 1 = More concise. (499 = "LDVLIV") 2 = More concise. (499 = "XDIX") 3 = More concise. (499 = "VDIV") 4 = Simplified. (499 = "ID") TRUE = Classic. FALSE = Simplified.

Func_roman_Category

Math

Func_roman_CategoryURL

Math

Func_roman_Desc

Converts a number into a roman number as a string.

Func_round_Arg_0

number

Func_round_Arg_1

num_digits

Func_round_Arg_2

round_Style

Func_round_ArgDesc_0

Number is the number you want to round

Func_round_ArgDesc_1

Num_digits specifies the number of digits to which you want to round number

Func_round_ArgDesc_2

round_Style specifies the style of rounding to use. 0 - Arithmetic Rounding (default) - This is the style of rounding used by Microsoft Excel. If the last significant digit in the rounding is a 5, the number is rounded up. 1 - Banker’s Rounding - This is the style of rounding used by Visual Studio. When the last significant digit is a 5, the preceding digit is used to determine whether to round up or down. If the digit is even, the number is rounded down. If it is odd, then the number is rounded up.

Func_round_Category

Math

Func_round_CategoryURL

Math

Func_round_Desc

Rounds a number to a specified number of digits

Func_rounddown_Arg_0

Number

Func_rounddown_Arg_1

Digits

Func_rounddown_ArgDesc_0

Number is a number to be rounded down.

Func_rounddown_ArgDesc_1

Digits indicates the number of decimal places to round to. Positive numbers indicates places after the decimal point, negative numbers indicate places before the decimal point.

Func_rounddown_Category

Math

Func_rounddown_CategoryURL

Math

Func_rounddown_Desc

Rounds a number to down to the specified number of digits.

Func_roundup_Arg_0

Number

Func_roundup_Arg_1

Digits

Func_roundup_ArgDesc_0

Number is a number to be rounded up.

Func_roundup_ArgDesc_1

Digits indicates the number of decimal places to round to. Positive numbers indicates places after the decimal point, negative numbers indicate places before the decimal point.

Func_roundup_Category

Math

Func_roundup_CategoryURL

Math

Func_roundup_Desc

Rounds a number to up to the specified number of digits.

Func_second_Arg_0

Date_value

Func_second_ArgDesc_0

The time value the second portion of which to return

Func_second_Category

DateAndTime

Func_second_CategoryURL

Date_and_Time

Func_second_Desc

Returns the second of a time value

Func_seriessum_Arg_0

InputValue

Func_seriessum_Arg_1

InitialPower

Func_seriessum_Arg_2

Step

Func_seriessum_Arg_3

Coefficient{0}

Func_seriessum_ArgDesc_0

InputValue is the input value to the power series.

Func_seriessum_ArgDesc_1

InitialPower is the initial power to which the InputValue will be raised.

Func_seriessum_ArgDesc_2

Step is the step which will be used to increase the power for each term in the series.

Func_seriessum_ArgDesc_3

Coefficient1, Coefficient2, …​, CoefficientN is a set of coefficients by which each successive power of InputValue is multiplied.

Func_seriessum_Category

Math

Func_seriessum_CategoryURL

Math

Func_seriessum_Desc

Returns the sum of a power series.

Func_sign_Arg_0

Number

Func_sign_ArgDesc_0

The number whose sign wil be returned.

Func_sign_Category

Math

Func_sign_CategoryURL

Math

Func_sign_Desc

Returns the sign of a number. (-1, 0, or 1)

Func_sin_Arg_0

number

Func_sin_ArgDesc_0

Number is the angle in radians for which you want the sine

Func_sin_Category

Math

Func_sin_CategoryURL

Math

Func_sin_Desc

Returns the sine of the given angle

Func_sinh_Arg_0

number

Func_sinh_ArgDesc_0

Number is any real number

Func_sinh_Category

Math

Func_sinh_CategoryURL

Math

Func_sinh_Desc

Returns the hyperbolic sine of a number

Func_sln_Arg_0

cost

Func_sln_Arg_1

salvage

Func_sln_Arg_2

life

Func_sln_ArgDesc_0

Cost is the initial cost of the asset

Func_sln_ArgDesc_1

Salvage is the value at the end of the depreciation

Func_sln_ArgDesc_2

Life is the number of periods over which the asset is depreciated

Func_sln_Category

Financial

Func_sln_CategoryURL

Financial

Func_sln_Desc

Returns the straight-line depreciation of an asset for one period

Func_sqrt_Arg_0

number

Func_sqrt_ArgDesc_0

Number is the number for which you want the square root

Func_sqrt_Category

Math

Func_sqrt_CategoryURL

Math

Func_sqrt_Desc

Returns a positive square root

Func_sqrtpi_Arg_0

Number

Func_sqrtpi_ArgDesc_0

The number which will be multiplied by Pi.

Func_sqrtpi_Category

Math

Func_sqrtpi_CategoryURL

Math

Func_sqrtpi_Desc

Returns the square root of the specified number times Pi.

Func_stdev_Arg_0

number{0}

Func_stdev_ArgDesc_0

Number1, number2, …​ are 1 to 30 argments specifying a sample of a population

Func_stdev_Category

Statistical

Func_stdev_CategoryURL

Statistical

Func_stdev_Desc

Returns the standard deviation of a population sample

Func_sum_Arg_0

number{0}

Func_sum_ArgDesc_0

Number1, number2, …​ are arguments for which you want the total value or sum

Func_sum_Category

Math

Func_sum_CategoryURL

Math

Func_sum_Desc

Adds all the numbers in a range of cells

Func_syd_Arg_0

cost

Func_syd_Arg_1

salvage

Func_syd_Arg_2

life

Func_syd_Arg_3

per

Func_syd_ArgDesc_0

Cost is the initial cost of the asset

Func_syd_ArgDesc_1

Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset)

Func_syd_ArgDesc_2

Life is the number of periods over which the asset is depreciated (sometimes called the useful life of the asset)

Func_syd_ArgDesc_3

Per is the period and must use the same units as life

Func_syd_Category

Financial

Func_syd_CategoryURL

Financial

Func_syd_Desc

Returns the sum-of-years' digits depreciation of an asset for a specified period

Func_tan_Arg_0

number

Func_tan_ArgDesc_0

Number is the angle in radians for which you want the tangent

Func_tan_Category

Math

Func_tan_CategoryURL

Math

Func_tan_Desc

Returns the tangent of the given angle

Func_tanh_Arg_0

number

Func_tanh_ArgDesc_0

Number is the angle in radians for which you want the hyperbolic tangent

Func_tanh_Category

Math

Func_tanh_CategoryURL

Math

Func_tanh_Desc

Returns the hyperbolic tangent of the given angle

Func_time_Arg_0

hour

Func_time_Arg_1

minute

Func_time_Arg_2

second

Func_time_ArgDesc_0

Hour is a number representing the time’s hour

Func_time_ArgDesc_1

Minute is a number representing the time’s minute

Func_time_ArgDesc_2

Second is a number representing the time’s second

Func_time_Category

DateAndTime

Func_time_CategoryURL

Date_and_Time

Func_time_Desc

Returns the .NET DateTime ticks value that represents a particular time

Func_timevalue_Arg_0

time_text

Func_timevalue_ArgDesc_0

Time_text is text that represents a date in the .NET DateTime format

Func_timevalue_Category

DateAndTime

Func_timevalue_CategoryURL

Date_and_Time

Func_timevalue_Desc

Returns the date value of the time represented by time formated in a string

Func_today_Category

DateAndTime

Func_today_CategoryURL

Date_and_Time

Func_today_Desc

Returns the current date. No arguments are passed to this function.

Func_trim_Arg_0

text

Func_trim_ArgDesc_0

Text is the text from which you want spaces removed

Func_trim_Category

TextAndData

Func_trim_CategoryURL

Text_and_Data

Func_trim_Desc

Removes all spaces from text except for single spaces between words

Func_true_Category

Logical

Func_true_CategoryURL

Logical

Func_true_Desc

Returns the logical value TRUE

Func_trunc_Arg_0

number

Func_trunc_Arg_1

num_digits

Func_trunc_ArgDesc_0

Number is the number you want to truncate

Func_trunc_ArgDesc_1

Num_digits is a number specifying the precision of the truncation. The default value for num_digits is 0 (zero)

Func_trunc_Category

Math

Func_trunc_CategoryURL

Math

Func_trunc_Desc

Truncates a number to an integer by removing the fractional part of the number

Func_type_Arg_0

value

Func_type_ArgDesc_0

Value is a number

Func_type_Category

Information

Func_type_CategoryURL

Information

Func_type_Desc

Returns the type of value

Func_upper_Arg_0

text

Func_upper_ArgDesc_0

Text is the text you want to convert to uppercase

Func_upper_Category

TextAndData

Func_upper_CategoryURL

Text_and_Data

Func_upper_Desc

Converts all lowercase letters in a text string to uppercase

Func_value_Arg_0

text

Func_value_ArgDesc_0

Text is the text enclosed in quotation marks or a reference to a cell containing the text you want to convert

Func_value_Category

TextAndData

Func_value_CategoryURL

Text_and_Data

Func_value_Desc

Converts a text string that represents a number to a number

Func_var_Arg_0

number{0}

Func_var_ArgDesc_0

Number1, number2, …​ are 1 to 30 argments specifying a sample of a population

Func_var_Category

Statistical

Func_var_CategoryURL

Statistical

Func_var_Desc

Returns the variance of a population sample

Func_weekday_Arg_0

Date

Func_weekday_Arg_1

ReturnType

Func_weekday_ArgDesc_0

Date is a date.

Func_weekday_ArgDesc_1

ReturnType determines which numbering scheme is used for the days of the week. 1 (default) = Sunday (1) through Saturday (7) 2 = Monday (1) through Sunday (7) 3 = Monday (0) through Sunday (6)

Func_weekday_Category

DateAndTime

Func_weekday_CategoryURL

DateAndTime

Func_weekday_Desc

Returns a number representing the day of the week of the specified date.

Func_weeknum_Arg_0

date

Func_weeknum_Arg_1

returnType

Func_weeknum_ArgDesc_0

Date is a date.

Func_weeknum_ArgDesc_1

ReturnType determines which day begins the week. 1 (default) = Sunday is the first day of the week. 2 = Monday is the first day of the week.

Func_weeknum_Category

DateAndTime

Func_weeknum_CategoryURL

DateAndTime

Func_weeknum_Desc

Returns the number of the week into which the specified date falls.

Func_workday_Arg_0

startDate

Func_workday_Arg_1

days

Func_workday_Arg_2

holiday{0}

Func_workday_ArgDesc_0

StartDate is the date from which to start.

Func_workday_ArgDesc_1

Days is the number of work days to offset from the start date.

Func_workday_ArgDesc_2

Holiday1, holiday2, …​, holidayN is any number of dates or range references containing dates that are to be considered non-working days.

Func_workday_Category

DateAndTime

Func_workday_CategoryURL

DateAndTime

Func_workday_Desc

Returns a work day the specified number of days from the specified date, excluding any specified holidays.

Func_year_Arg_0

Date_value

Func_year_ArgDesc_0

Date_value is a .NET DateTime number that represents a particular date

Func_year_Category

DateAndTime

Func_year_CategoryURL

Date_and_Time

Func_year_Desc

Returns the year of a date value

Func_yearfrac_Arg_0

StartDate

Func_yearfrac_Arg_1

EndDate

Func_yearfrac_Arg_2

Basis

Func_yearfrac_ArgDesc_0

Start date is the starting date in the range.

Func_yearfrac_ArgDesc_1

End date is the ending date in the range.

Func_yearfrac_ArgDesc_2

Basis determines the basis for the day count to use. 0 (Default = US (NASD) 30/360 1 = Actual/actual 2 = Actual/360 3 = Actual/365 4 = European 30/360

Func_yearfrac_Category

DateAndTime

Func_yearfrac_CategoryURL

DateAndTime

Func_yearfrac_Desc

Returns a fraction representing the part of a year specified between the specified start date and end date.

NamedReference_Category_All

(All)

NamedReference_Category_Unassigned

(Unassigned)

Operand_Category_Controls

Controls

Operand_Category_NamedReferences

Named References

TokenPattern_ArgumentSeparator

ARG_SEP

TokenPattern_LeftParen

LEFT_PAREN

TokenPattern_Number

NUMBER

TokenPattern_OperatorConcatenate

OP_CONCAT

TokenPattern_OperatorDivide

OP_DIV

TokenPattern_OperatorDot

OP_DOT

TokenPattern_OperatorEqual

OP_EQUAL

TokenPattern_OperatorExponent

OP_EXPON

TokenPattern_OperatorGreaterThan

OP_GT

TokenPattern_OperatorGreaterThanEqual

OP_GE

TokenPattern_OperatorLessThan

OP_LT

TokenPattern_OperatorLessThanEqual

OP_LE

TokenPattern_OperatorMinus

OP_MINUS

TokenPattern_OperatorMultiply

OP_TIMES

TokenPattern_OperatorNotEqual

OP_NE

TokenPattern_OperatorNotEqualAlternate

OP_ALT_NE

TokenPattern_OperatorPercent

OP_PERCENT

TokenPattern_OperatorPlus

OP_PLUS

TokenPattern_QuotedString

QUOTED_STRING

TokenPattern_RangeSeparator

RANGE_SEP

TokenPattern_Reference

REFERENCE

TokenPattern_RightParen

RIGHT_PAREN

TokenPattern_Text

TEXT

TokenPattern_WhiteSpace

WHITESPACE