PC World 2002 May/PCWorld_2002-05_cd.bin/Software/Komercni/ability/2000/HLPSHARE.Z/ABFUNC.CNT

Microsoft Windows Help File Content | 2000-11-30 | 12.1 KB | 278 lines

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