:Base abfunc.HLP
1 Function reference
2 Functions - general reference
3 Function reference=Function_reference
3 Using built-in functions=Using_built_in_functions
3 Using the function dialog box to build formulas=Using_the_function_dialog_box_to_build_formulas
3 Text arguments=Text_arguments
3 Arrays=Arrays
3 Logical operators=Logical_operators
3 Relational operators=Relational_operators
3 Arithmetical operators=Arithmetical_operators
3 Priority of evaluation of operators=Priority_of_evaluation_of_operators
3 Cell error indicators=Cell_error_indicators
2 Date functions
3 Date functions=Date_functions
3 Year 2000=Year_2000
3 DATE(year, month, day)=DATE_year_month_day
3 DATEVALUE(date_text)=DATEVALUE_date_text
3 DAY(date-code)=DAY_date_code
3 DAYS360(start_date, end_date, method)=DAYS360_start_date_end_date_method
3 EDATE(start_date, months)=EDATE_start_date_months
3 EOMONTH(start_date, months)=EOMONTH_start_date_months
3 HOUR(time_code)=HOUR_time_code
3 MINUTE(time_code)=MINUTE_time_code
3 MONTH(date-code)=MONTH_date_code
3 NETWORKDAYS(start_date, end_date, list_holidays)=NETWORKDAYS_start_date_end_date_list_holidays
3 NOW( )=NOW
3 SECOND(time_code)=SECOND_time_code
3 TIME(hour, minute, second)=TIME_hour_minute_second
3 TIMEVALUE(time_text)=TIMEVALUE_time_text
3 TODAY( )=TODAY
3 WEEKDAY(date_code)=WEEKDAY_date_code
3 WEEKNUM(date_code, return_type)=WEEKNUM_date_code_return_type
3 WORKDAY(start_date, days, list_holidays)=WORKDAY_start_date_days_list_holidays
3 YEAR(date-code)=YEAR_date_code
3 YEARFRAC(start_date, end_date, basis)=YEARFRAC_start_date_end_date_basis
2 Financial functions
3 Financial functions=Financial_functions
3 ACCRINTM(issue, settlement, rate, par, basis)=ACCRINTM_issue_settlement_rate_par_basis
3 COMPOUND (principal, interest, periods)=COMPOUND_principal_interest_periods
3 COUPDAYBS(settlement, maturity, frequency, basis)=COUPDAYBS_settlement_maturity_frequency_basis
3 COUPDAYS(settlement, maturity, frequency, basis)=COUPDAYS_settlement_maturity_frequency_basis
3 COUPDAYSNC(settlement, maturity, frequency, basis)=COUPDAYSNC_settlement_maturity_frequency_basis
3 COUPNCD(settlement, maturity, frequency, basis)=COUPNCD_settlement_maturity_frequency_basis
3 COUPNUM(settlement, maturity, frequency, basis)=COUPNUM_settlement_maturity_frequency_basis
3 COUPPCD(settlement, maturity, frequency, basis)=COUPPCD_settlement_maturity_frequency_basis
3 DB(cost, salvage, life, period, month)=DB_cost_salvage_life_period_month
3 DISC(settlement, maturity, par, redemption, basis)=DISC_settlement_maturity_par_redemption_basis
3 DOLLARDE(fractional_dollar, fraction)=DOLLARDE_fractional_dollar_fraction
3 EFFECT(nominal_rate, npery)=EFFECT_nominal_rate_npery
3 FV(payment, rate, periods)=FV_payment_rate_periods
3 INTRATE(settlement, maturity, investment, redemption, basis)=INTRATE_settlement_maturity_investment_redemption_basis
3 IRR(guess, initial, list)=IRR_guess_initial_list
3 MIRR(finance_rate, reinvest_rate, list)=MIRR_finance_rate_reinvest_rate_list
3 NOMINAL(effect_rate, npery)=NOMINAL_effect_rate_npery
3 NPV(rate, list)=NPV_rate_list
3 PMT(principal, rate, periods)=PMT_principal_rate_periods
3 PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)=PRICE_settlement_maturity_rate_yield_redemption_frequency_basis
3 PRICEDISC(settlement, maturity, discount, redemption, basis)=PRICEDISC_settlement_maturity_discount_redemption_basis
3 PRICEMAT(settlement, maturity, issue, rate, yield, basis)=PRICEMAT_settlement_maturity_issue_rate_yield_basis
3 PV(payment, rate, periods)=PV_payment_rate_periods
3 RECEIVED(settlement, maturity, investment, discount, basis)=RECEIVED_settlement_maturity_investment_discount_basis
3 TAXBAND(income, taxrates, taxbands)=TAXBAND_income_taxrates_taxbands
3 TBILLPRICE(settlement, maturity, discount)=TBILLPRICE_settlement_maturity_discount
3 TBILLYIELD(settlement, maturity, par)=TBILLYIELD_settlement_maturity_par
2 Logical functions
3 Logical functions=Logical_functions
3 AND(list of logical conditions)=AND_list_of_logical_conditions
3 IF(x, true, false)=IF_x_true_false
3 NOT(logical)=NOT_logical
3 OR(list of logical conditions)=OR_list_of_logical_conditions
2 Mathematical functions
3 Mathematical functions=Mathematical_functions
3 ABS(x)=ABS_x
3 ACOSH(x)=ACOSH_x
3 ACOTANH(x)=ACOTANH_x
3 ASINH(x)=ASINH_x
3 ATANH(x)=ATANH_x
3 COSH(x)=COSH_x
3 COTANH(x)=COTANH_x
3 DIVIDE(list)=DIVIDE_list
3 EVEN(x)=EVEN_x
3 EXP(x)=EXP_x
3 FACT(n)=FACT_n
3 FACTDOUBLE(n)=FACTDOUBLE_n
3 GCD(list)=GCD_list
3 INT(x)=INT_x
3 LCM(list)=LCM_list
3 LN(x)=LN_x
3 LOG(x, b)=LOG_x_b
3 LOG10(x)=LOG10_x
3 MDETERM(array)=MDETERM_array
3 MINUS(list)=MINUS_list
3 MOD(x, y)=MOD_x_y
3 MULTINOMIAL(list)=MULTINOMIAL_list
3 ODD(x)=ODD_x
3 PLUS(list)=PLUS_list
3 POWER(list)=POWER_list
3 RAND(x)=RAND_x
3 RANDBETWEEN(bottom, top)=RANDBETWEEN_bottom_top
3 ROUND(x, y)=ROUND_x_y
3 ROUNDDOWN(number, num_digits)=ROUNDDOWN_number_num_digits
3 ROUNDUP(number, num_digits)=ROUNDUP_number_num_digits
3 SERIESSUM(x, n, m, coefficients)=SERIESSUM_x_n_m_coefficients
3 SIGN(x)=SIGN_x
3 SINH(x)=SINH_x
3 SQR(x)=SQR_x
3 SQRT(x)=SQRT_x
3 SUM(list)=SUM_list
3 SUMIF(list, condition)=SUMIF_list_condition
3 SUMSQ(list)=SUMSQ_list
3 SUMTIMES(range1, range2)=SUMTIMES_range1_range2
3 SUMX2MY2(range_x, range_y)=SUMX2MY2_range_x_range_y
3 SUMX2PY2(range_x, range_y)=SUMX2PY2_range_x_range_y
3 SUMXMY2(range_x, range_y)=SUMXMY2_range_x_range_y
3 SUMXPY2(range_x, range_y)=SUMXPY2_range_x_range_y
3 TANH(x)=TANH_x
3 TIMES(list)=TIMES_list
3 TOTAL(list)=TOTAL_list
2 Trigonometric functions
3 Trigonometric functions=Trigonometric_functions
3 ACOS(x)=ACOS_x
3 ACOTAN(x)=ACOTAN_x
3 ASIN(x)=ASIN_x
3 ATAN(x)=ATAN_x
3 ATAN2(x, y)=ATAN2_x_y
3 COS(x)=COS_x
3 COTAN(x)=COTAN_x
3 DEGREES(angle)=DEGREES_angle
3 PI()=PI
3 RADIANS(angle)=RADIANS_angle
3 SIN(x)=SIN_x
3 SQRTPI(x)=SQRTPI_x
3 TAN(x)=TAN_x
2 Lookup functions
3 Lookup functions=Lookup_functions
3 ADDRESS(row_number, column_number, abs_mode)=ADDRESS_row_number_column_number_abs_mode
3 AREAS(list)=AREAS_list
3 CHOOSE(index_num, list)=CHOOSE_index_num_list
3 COLUMN(ref)=COLUMN_ref
3 COLUMNS(array)=COLUMNS_array
3 FIND(value, list)=FIND_value_list
3 FINDEX(value, list)=FINDEX_value_list
3 INDEX(x, list)=INDEX_x_list
3 INDIRECT(ref_as_text, mode)=INDIRECT_ref_as_text_mode
3 LOOKUP(x, in-range, outrange)=LOOKUP_x_in_range_outrange
3 LOOKUPEX(value, in_range, out_range)=LOOKUPEX_value_in_range_out_range
3 ROW(ref)=ROW_ref
3 ROWS(list)=ROWS_list
2 Information functions
3 Information functions=Information_functions
3 COUNTBLANK(list)=COUNTBLANK_list
3 ISBLANK(value)=ISBLANK_value
3 ISERR(list)=ISERR_list
3 ISERROR(value)=ISERROR_value
3 ISEVEN(value)=ISEVEN_value
3 ISNUMBER(value)=ISNUMBER_value
3 ISODD(value)=ISODD_value
3 ISREF(value)=ISREF_value
3 ISTEXT(value)=ISTEXT_value
2 Statistical functions
3 Statistical functions=Statistical_functions
3 AVEDEV(list)=AVEDEV_list
3 AVERAGE(list) or AVG(list)=AVERAGE_list_or_AVG_list
3 BINOMDIST(number, trials, probability, cumulative)=BINOMDIST_number_trials_probability_cumulative
3 COMB(n, m)=COMB_n_m
3 CORREL(array1, array2)=CORREL_array1_array2
3 COUNT(list)=COUNT_list
3 COUNTIF(list, condition)=COUNTIF_list_condition
3 COUNTN(list)=COUNTN_list
3 COVAR(array1, array2)=COVAR_array1_array2
3 DEVSQ(list)=DEVSQ_list
3 EXPONDIST(x, lambda, cumulative)=EXPONDIST_x_lambda_cumulative
3 FISHER(x)=FISHER_x
3 FISHERINV(y)=FISHERINV_y
3 FORECAST(x, array_y, array_x)=FORECAST_x_array_y_array_x
3 GAMMADIST(x, alpha, beta)=GAMMADIST_x_alpha_beta
3 GAMMALN(x)=GAMMALN_x
3 GEOMEAN(list)=GEOMEAN_list
3 HARMEAN(list)=HARMEAN_list
3 HYPGEOMDIST(sample, n_sample, population, n_population)=HYPGEOMDIST_sample_n_sample_population_n_population
3 INTERCEPT(array_y, array_x)=INTERCEPT_array_y_array_x
3 KURT(list)=KURT_list
3 LARGE(k, list)=LARGE_k_list
3 MAX(list)=MAX_list
3 MEDIAN(list)=MEDIAN_list
3 MIN(list)=MIN_list
3 MODE(list)=MODE_list
3 NEGBINOMDIST(number_f, number_s, probability_s)=NEGBINOMDIST_number_f_number_s_probability_s
3 NORMDIST(x, mean, stdev)=NORMDIST_x_mean_stdev
3 PEARSON(array_x, array_y)=PEARSON_array_x_array_y
3 PERCENTILE(k, array)=PERCENTILE_k_array
3 PERCENTRANK(x, array)=PERCENTRANK_x_array
3 PERM(n, m)=PERM_n_m
3 POISSON(x, mean, cumulative)=POISSON_x_mean_cumulative
3 PROB(x_range, prob_range, lower_limit, upper_limit)=PROB_x_range_prob_range_lower_limit_upper_limit
3 QUARTILE(quart, array)=QUARTILE_quart_array
3 RANK(number, ref, order)=RANK_number_ref_order
3 RSQ(array_x, array_y)=RSQ_array_x_array_y
3 SKEW(list)=SKEW_list
3 SLOPE(array_x, array_y)=SLOPE_array_x_array_y
3 SMALL(k, list)=SMALL_k_list
3 STANDARDIZE(x, mean, stdev)=STANDARDIZE_x_mean_stdev
3 STD(list) or STDEV(list)=STD_list_or_STDEV_list
3 STDEVP(list)=STDEVP_list
3 STEYX(array_y, array_x)=STEYX_array_y_array_x
3 VAR(list)=VAR_list
3 VARP(list)=VARP_list
3 WAVG(array_x, array_y)=WAVG_array_x_array_y
3 WEIBULL(x, alpha, beta, cumulative)=WEIBULL_x_alpha_beta_cumulative
2 Text functions
3 Text functions=Text_functions
3 CHAR(number)=CHAR_number
3 CLEAN(text)=CLEAN_text
3 CODE(text)=CODE_text
3 CONCAT(text_list)=CONCAT_text_list
3 CONCATENATE(text_list)=CONCATENATE_text_list
3 DOLLAR(number, precision)=DOLLAR_number_precision
3 EXACT(text1, text2)=EXACT_text1_text2
3 FINDTEXT(find_text, within_text, start_num)=FINDTEXT_find_text_within_text_start_num
3 FIXED(number, precision, commas)=FIXED_number_precision_commas
3 LEFT(text, num_chars)=LEFT_text_num_chars
3 LEN(text)=LEN_text
3 LOWER(text)=LOWER_text
3 MID(text, start_num, num_chars)=MID_text_start_num_num_chars
3 PROPER(text)=PROPER_text
3 REPLACE(old_text, start_num, num_chars, new_text)=REPLACE_old_text_start_num_num_chars_new_text
3 REPT(text, number_times)=REPT_text_number_times
3 RIGHT(text, num_chars)=RIGHT_text_num_chars
3 SEARCHTEXT(find_text, within_text, start_num)=SEARCHTEXT_find_text_within_text_start_num
3 SUBSTITUTE(text, old_text, new_text, instance_num)=SUBSTITUTE_text_old_text_new_text_instance_num
3 T(value)=T_value
3 TRIM(text)=TRIM_text
3 UPPER(text)=UPPER_text
3 VALUE(text)=VALUE_text
2 Document functions
3 Document Functions=Document_Functions
3 AUTHOR()=AUTHOR
3 COMMENTS()=COMMENTS
3 CREATEDATE()=CREATEDATE
3 EDITTIME()=EDITTIME
3 FILENAME()=FILENAME
3 FILESIZE()=FILESIZE
3 KEYWORDS()=KEYWORDS
3 MERGECOUNT()=MERGECOUNT
3 MERGEREC()=MERGEREC
3 NUMCHARS()=NUMCHARS
3 NUMPAGES()=NUMPAGES
3 NUMWORDS()=NUMWORDS
3 PAGE()=PAGE
3 PRINTDATE()=PRINTDATE
3 REVNUM( )=REVNUM
3 SAVEDATE()=SAVEDATE
3 SUBJECT()=SUBJECT
3 TITLE()=TITLE
2 Remote functions
3 Remote functions=Remote_functions
3 DBFIELDCOUNT(database, source)=DBFIELDCOUNT_database_source
3 DBFIELDNAME(database, source, index)=DBFIELDNAME_database_source_index
3 DBFILTER(database, table, filter, field_name, rec_num)=DBFILTER_database_table_filter_field_name_rec_num
3 DBFILTERSORT(database, table, filter, sort, field_name, rec_num)=DBFILTERSORT_database_table_filter_sort_field_name_rec_num
3 DBGET(database, source, field_name, rec_num)=DBGET_database_source_field_name_rec_num
3 DBQUERYCOUNT(database)=DBQUERYCOUNT_database
3 DBQUERYNAME(database, index)=DBQUERYNAME_database_index
3 DBRELATIONCOUNT(database)=DBRELATIONCOUNT_database
3 DBRELATIONNAME(database, index)=DBRELATIONNAME_database_index
3 DBSORT(database, table, sort, field_name, rec_num)=DBSORT_database_table_sort_field_name_rec_num
3 DBSQL(database, SQL_statement, field_name, rec_num)=DBSQL_database_SQL_statement_field_name_rec_num
3 DBSQLFILTER(database, table, filter, field_name, rec_num)=DBSQLFILTER_database_table_filter_field_name_rec_num
3 DBSQLSORT(database, table, sort, field_name, rec_num)=DBSQLSORT_database_table_sort_field_name_rec_num
3 DBSQLFILTERSORT(database, table, filter, sort, field_name, rec_num)=DBSQLFILTERSORT_database_table_filter_sort_field_name_rec_num
3 DBTABLECOUNT(database)=DBTABLECOUNT_database
3 DBTABLENAME(database, index)=DBTABLENAME_database_index
3 HYPERLINK(link location, friendly name)=HYPERLINK_link_location_friendly_name
3 REMOTE(document_name, reference_name)=REMOTE_document_name_reference_name
3 SSGET(spreadsheet, reference)=SSGET_spreadsheet_reference
3 WPGET(document, fieldname)=WPGET_document_fieldname