home *** CD-ROM | disk | FTP | other *** search
/ PC World 2002 April / PCWorld_2002-04_cd.bin / Akce / demo / hlpshare.z / ABFUMS.CNT (.txt) < prev    next >
Microsoft Windows Help File Content  |  2001-11-22  |  12KB  |  278 lines
  1. :Base abfunc.HLP
  2. 1 Function reference
  3. 2 Functions - general reference
  4. 3 Function reference=Function_reference
  5. 3 Using built-in functions=Using_built_in_functions
  6. 3 Using the function dialog box to build formulas=Using_the_function_dialog_box_to_build_formulas
  7. 3 Text arguments=Text_arguments
  8. 3 Arrays=Arrays
  9. 3 Logical operators=Logical_operators
  10. 3 Relational operators=Relational_operators
  11. 3 Arithmetical operators=Arithmetical_operators
  12. 3 Priority of evaluation of operators=Priority_of_evaluation_of_operators
  13. 3 Cell error indicators=Cell_error_indicators
  14. 2 Date functions
  15. 3 Date functions=Date_functions
  16. 3 Year 2000=Year_2000
  17. 3 DATE(year, month, day)=DATE_year_month_day
  18. 3 DATEVALUE(date_text)=DATEVALUE_date_text
  19. 3 DAY(date-code)=DAY_date_code
  20. 3 DAYS360(start_date, end_date, method)=DAYS360_start_date_end_date_method
  21. 3 EDATE(start_date, months)=EDATE_start_date_months
  22. 3 EOMONTH(start_date, months)=EOMONTH_start_date_months
  23. 3 HOUR(time_code)=HOUR_time_code
  24. 3 MINUTE(time_code)=MINUTE_time_code
  25. 3 MONTH(date-code)=MONTH_date_code
  26. 3 NETWORKDAYS(start_date, end_date, list_holidays)=NETWORKDAYS_start_date_end_date_list_holidays
  27. 3 NOW( )=NOW
  28. 3 SECOND(time_code)=SECOND_time_code
  29. 3 TIME(hour, minute, second)=TIME_hour_minute_second
  30. 3 TIMEVALUE(time_text)=TIMEVALUE_time_text
  31. 3 TODAY( )=TODAY
  32. 3 WEEKDAY(date_code)=WEEKDAY_date_code
  33. 3 WEEKNUM(date_code, return_type)=WEEKNUM_date_code_return_type
  34. 3 WORKDAY(start_date, days, list_holidays)=WORKDAY_start_date_days_list_holidays
  35. 3 YEAR(date-code)=YEAR_date_code
  36. 3 YEARFRAC(start_date, end_date, basis)=YEARFRAC_start_date_end_date_basis
  37. 2 Financial functions
  38. 3 Financial functions=Financial_functions
  39. 3 ACCRINTM(issue, settlement, rate, par, basis)=ACCRINTM_issue_settlement_rate_par_basis
  40. 3 COMPOUND (principal, interest, periods)=COMPOUND_principal_interest_periods
  41. 3 COUPDAYBS(settlement, maturity, frequency, basis)=COUPDAYBS_settlement_maturity_frequency_basis
  42. 3 COUPDAYS(settlement, maturity, frequency, basis)=COUPDAYS_settlement_maturity_frequency_basis
  43. 3 COUPDAYSNC(settlement, maturity, frequency, basis)=COUPDAYSNC_settlement_maturity_frequency_basis
  44. 3 COUPNCD(settlement, maturity, frequency, basis)=COUPNCD_settlement_maturity_frequency_basis
  45. 3 COUPNUM(settlement, maturity, frequency, basis)=COUPNUM_settlement_maturity_frequency_basis
  46. 3 COUPPCD(settlement, maturity, frequency, basis)=COUPPCD_settlement_maturity_frequency_basis
  47. 3 DB(cost, salvage, life, period, month)=DB_cost_salvage_life_period_month
  48. 3 DISC(settlement, maturity, par, redemption, basis)=DISC_settlement_maturity_par_redemption_basis
  49. 3 DOLLARDE(fractional_dollar, fraction)=DOLLARDE_fractional_dollar_fraction
  50. 3 EFFECT(nominal_rate, npery)=EFFECT_nominal_rate_npery
  51. 3 FV(payment, rate, periods)=FV_payment_rate_periods
  52. 3 INTRATE(settlement, maturity, investment, redemption, basis)=INTRATE_settlement_maturity_investment_redemption_basis
  53. 3 IRR(guess, initial, list)=IRR_guess_initial_list
  54. 3 MIRR(finance_rate, reinvest_rate, list)=MIRR_finance_rate_reinvest_rate_list
  55. 3 NOMINAL(effect_rate, npery)=NOMINAL_effect_rate_npery
  56. 3 NPV(rate, list)=NPV_rate_list
  57. 3 PMT(principal, rate, periods)=PMT_principal_rate_periods
  58. 3 PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)=PRICE_settlement_maturity_rate_yield_redemption_frequency_basis
  59. 3 PRICEDISC(settlement, maturity, discount, redemption, basis)=PRICEDISC_settlement_maturity_discount_redemption_basis
  60. 3 PRICEMAT(settlement, maturity, issue, rate, yield, basis)=PRICEMAT_settlement_maturity_issue_rate_yield_basis
  61. 3 PV(payment, rate, periods)=PV_payment_rate_periods
  62. 3 RECEIVED(settlement, maturity, investment, discount, basis)=RECEIVED_settlement_maturity_investment_discount_basis
  63. 3 TAXBAND(income, taxrates, taxbands)=TAXBAND_income_taxrates_taxbands
  64. 3 TBILLPRICE(settlement, maturity, discount)=TBILLPRICE_settlement_maturity_discount
  65. 3 TBILLYIELD(settlement, maturity, par)=TBILLYIELD_settlement_maturity_par
  66. 2 Logical functions
  67. 3 Logical functions=Logical_functions
  68. 3 AND(list of logical conditions)=AND_list_of_logical_conditions
  69. 3 IF(x, true, false)=IF_x_true_false
  70. 3 NOT(logical)=NOT_logical
  71. 3 OR(list of logical conditions)=OR_list_of_logical_conditions
  72. 2 Mathematical functions
  73. 3 Mathematical functions=Mathematical_functions
  74. 3 ABS(x)=ABS_x
  75. 3 ACOSH(x)=ACOSH_x
  76. 3 ACOTANH(x)=ACOTANH_x
  77. 3 ASINH(x)=ASINH_x
  78. 3 ATANH(x)=ATANH_x
  79. 3 COSH(x)=COSH_x
  80. 3 COTANH(x)=COTANH_x
  81. 3 DIVIDE(list)=DIVIDE_list
  82. 3 EVEN(x)=EVEN_x
  83. 3 EXP(x)=EXP_x
  84. 3 FACT(n)=FACT_n
  85. 3 FACTDOUBLE(n)=FACTDOUBLE_n
  86. 3 GCD(list)=GCD_list
  87. 3 INT(x)=INT_x
  88. 3 LCM(list)=LCM_list
  89. 3 LN(x)=LN_x
  90. 3 LOG(x, b)=LOG_x_b
  91. 3 LOG10(x)=LOG10_x
  92. 3 MDETERM(array)=MDETERM_array
  93. 3 MINUS(list)=MINUS_list
  94. 3 MOD(x, y)=MOD_x_y
  95. 3 MULTINOMIAL(list)=MULTINOMIAL_list
  96. 3 ODD(x)=ODD_x
  97. 3 PLUS(list)=PLUS_list
  98. 3 POWER(list)=POWER_list
  99. 3 RAND(x)=RAND_x
  100. 3 RANDBETWEEN(bottom, top)=RANDBETWEEN_bottom_top
  101. 3 ROUND(x, y)=ROUND_x_y
  102. 3 ROUNDDOWN(number, num_digits)=ROUNDDOWN_number_num_digits
  103. 3 ROUNDUP(number, num_digits)=ROUNDUP_number_num_digits
  104. 3 SERIESSUM(x, n, m, coefficients)=SERIESSUM_x_n_m_coefficients
  105. 3 SIGN(x)=SIGN_x
  106. 3 SINH(x)=SINH_x
  107. 3 SQR(x)=SQR_x
  108. 3 SQRT(x)=SQRT_x
  109. 3 SUM(list)=SUM_list
  110. 3 SUMIF(list, condition)=SUMIF_list_condition
  111. 3 SUMSQ(list)=SUMSQ_list
  112. 3 SUMTIMES(range1, range2)=SUMTIMES_range1_range2
  113. 3 SUMX2MY2(range_x, range_y)=SUMX2MY2_range_x_range_y
  114. 3 SUMX2PY2(range_x, range_y)=SUMX2PY2_range_x_range_y
  115. 3 SUMXMY2(range_x, range_y)=SUMXMY2_range_x_range_y
  116. 3 SUMXPY2(range_x, range_y)=SUMXPY2_range_x_range_y
  117. 3 TANH(x)=TANH_x
  118. 3 TIMES(list)=TIMES_list
  119. 3 TOTAL(list)=TOTAL_list
  120. 2 Trigonometric functions
  121. 3 Trigonometric functions=Trigonometric_functions
  122. 3 ACOS(x)=ACOS_x
  123. 3 ACOTAN(x)=ACOTAN_x
  124. 3 ASIN(x)=ASIN_x
  125. 3 ATAN(x)=ATAN_x
  126. 3 ATAN2(x, y)=ATAN2_x_y
  127. 3 COS(x)=COS_x
  128. 3 COTAN(x)=COTAN_x
  129. 3 DEGREES(angle)=DEGREES_angle
  130. 3 PI()=PI
  131. 3 RADIANS(angle)=RADIANS_angle
  132. 3 SIN(x)=SIN_x
  133. 3 SQRTPI(x)=SQRTPI_x
  134. 3 TAN(x)=TAN_x
  135. 2 Lookup functions
  136. 3 Lookup functions=Lookup_functions
  137. 3 ADDRESS(row_number, column_number, abs_mode)=ADDRESS_row_number_column_number_abs_mode
  138. 3 AREAS(list)=AREAS_list
  139. 3 CHOOSE(index_num, list)=CHOOSE_index_num_list
  140. 3 COLUMN(ref)=COLUMN_ref
  141. 3 COLUMNS(array)=COLUMNS_array
  142. 3 FIND(value, list)=FIND_value_list
  143. 3 FINDEX(value, list)=FINDEX_value_list
  144. 3 INDEX(x, list)=INDEX_x_list
  145. 3 INDIRECT(ref_as_text, mode)=INDIRECT_ref_as_text_mode
  146. 3 LOOKUP(x, in-range, outrange)=LOOKUP_x_in_range_outrange
  147. 3 LOOKUPEX(value, in_range, out_range)=LOOKUPEX_value_in_range_out_range
  148. 3 ROW(ref)=ROW_ref
  149. 3 ROWS(list)=ROWS_list
  150. 2 Information functions
  151. 3 Information functions=Information_functions
  152. 3 COUNTBLANK(list)=COUNTBLANK_list
  153. 3 ISBLANK(value)=ISBLANK_value
  154. 3 ISERR(list)=ISERR_list
  155. 3 ISERROR(value)=ISERROR_value
  156. 3 ISEVEN(value)=ISEVEN_value
  157. 3 ISNUMBER(value)=ISNUMBER_value
  158. 3 ISODD(value)=ISODD_value
  159. 3 ISREF(value)=ISREF_value
  160. 3 ISTEXT(value)=ISTEXT_value
  161. 2 Statistical functions
  162. 3 Statistical functions=Statistical_functions
  163. 3 AVEDEV(list)=AVEDEV_list
  164. 3 AVERAGE(list) or AVG(list)=AVERAGE_list_or_AVG_list
  165. 3 BINOMDIST(number, trials, probability, cumulative)=BINOMDIST_number_trials_probability_cumulative
  166. 3 COMB(n, m)=COMB_n_m
  167. 3 CORREL(array1, array2)=CORREL_array1_array2
  168. 3 COUNT(list)=COUNT_list
  169. 3 COUNTIF(list, condition)=COUNTIF_list_condition
  170. 3 COUNTN(list)=COUNTN_list
  171. 3 COVAR(array1, array2)=COVAR_array1_array2
  172. 3 DEVSQ(list)=DEVSQ_list
  173. 3 EXPONDIST(x, lambda, cumulative)=EXPONDIST_x_lambda_cumulative
  174. 3 FISHER(x)=FISHER_x
  175. 3 FISHERINV(y)=FISHERINV_y
  176. 3 FORECAST(x, array_y, array_x)=FORECAST_x_array_y_array_x
  177. 3 GAMMADIST(x, alpha, beta)=GAMMADIST_x_alpha_beta
  178. 3 GAMMALN(x)=GAMMALN_x
  179. 3 GEOMEAN(list)=GEOMEAN_list
  180. 3 HARMEAN(list)=HARMEAN_list
  181. 3 HYPGEOMDIST(sample, n_sample, population, n_population)=HYPGEOMDIST_sample_n_sample_population_n_population
  182. 3 INTERCEPT(array_y, array_x)=INTERCEPT_array_y_array_x
  183. 3 KURT(list)=KURT_list
  184. 3 LARGE(k, list)=LARGE_k_list
  185. 3 MAX(list)=MAX_list
  186. 3 MEDIAN(list)=MEDIAN_list
  187. 3 MIN(list)=MIN_list
  188. 3 MODE(list)=MODE_list
  189. 3 NEGBINOMDIST(number_f, number_s, probability_s)=NEGBINOMDIST_number_f_number_s_probability_s
  190. 3 NORMDIST(x, mean, stdev)=NORMDIST_x_mean_stdev
  191. 3 PEARSON(array_x, array_y)=PEARSON_array_x_array_y
  192. 3 PERCENTILE(k, array)=PERCENTILE_k_array
  193. 3 PERCENTRANK(x, array)=PERCENTRANK_x_array
  194. 3 PERM(n, m)=PERM_n_m
  195. 3 POISSON(x, mean, cumulative)=POISSON_x_mean_cumulative
  196. 3 PROB(x_range, prob_range, lower_limit, upper_limit)=PROB_x_range_prob_range_lower_limit_upper_limit
  197. 3 QUARTILE(quart, array)=QUARTILE_quart_array
  198. 3 RANK(number, ref, order)=RANK_number_ref_order
  199. 3 RSQ(array_x, array_y)=RSQ_array_x_array_y
  200. 3 SKEW(list)=SKEW_list
  201. 3 SLOPE(array_x, array_y)=SLOPE_array_x_array_y
  202. 3 SMALL(k, list)=SMALL_k_list
  203. 3 STANDARDIZE(x, mean, stdev)=STANDARDIZE_x_mean_stdev
  204. 3 STD(list) or STDEV(list)=STD_list_or_STDEV_list
  205. 3 STDEVP(list)=STDEVP_list
  206. 3 STEYX(array_y, array_x)=STEYX_array_y_array_x
  207. 3 VAR(list)=VAR_list
  208. 3 VARP(list)=VARP_list
  209. 3 WAVG(array_x, array_y)=WAVG_array_x_array_y
  210. 3 WEIBULL(x, alpha, beta, cumulative)=WEIBULL_x_alpha_beta_cumulative
  211. 2 Text functions
  212. 3 Text functions=Text_functions
  213. 3 CHAR(number)=CHAR_number
  214. 3 CLEAN(text)=CLEAN_text
  215. 3 CODE(text)=CODE_text
  216. 3 CONCAT(text_list)=CONCAT_text_list
  217. 3 CONCATENATE(text_list)=CONCATENATE_text_list
  218. 3 DOLLAR(number, precision)=DOLLAR_number_precision
  219. 3 EXACT(text1, text2)=EXACT_text1_text2
  220. 3 FINDTEXT(find_text, within_text, start_num)=FINDTEXT_find_text_within_text_start_num
  221. 3 FIXED(number, precision, commas)=FIXED_number_precision_commas
  222. 3 LEFT(text, num_chars)=LEFT_text_num_chars
  223. 3 LEN(text)=LEN_text
  224. 3 LOWER(text)=LOWER_text
  225. 3 MID(text, start_num, num_chars)=MID_text_start_num_num_chars
  226. 3 PROPER(text)=PROPER_text
  227. 3 REPLACE(old_text, start_num, num_chars, new_text)=REPLACE_old_text_start_num_num_chars_new_text
  228. 3 REPT(text, number_times)=REPT_text_number_times
  229. 3 RIGHT(text, num_chars)=RIGHT_text_num_chars
  230. 3 SEARCHTEXT(find_text, within_text, start_num)=SEARCHTEXT_find_text_within_text_start_num
  231. 3 SUBSTITUTE(text, old_text, new_text, instance_num)=SUBSTITUTE_text_old_text_new_text_instance_num
  232. 3 T(value)=T_value
  233. 3 TRIM(text)=TRIM_text
  234. 3 UPPER(text)=UPPER_text
  235. 3 VALUE(text)=VALUE_text
  236. 2 Document functions
  237. 3 Document Functions=Document_Functions
  238. 3 AUTHOR()=AUTHOR
  239. 3 COMMENTS()=COMMENTS
  240. 3 CREATEDATE()=CREATEDATE
  241. 3 EDITTIME()=EDITTIME
  242. 3 FILENAME()=FILENAME
  243. 3 FILESIZE()=FILESIZE
  244. 3 KEYWORDS()=KEYWORDS
  245. 3 MERGECOUNT()=MERGECOUNT
  246. 3 MERGEREC()=MERGEREC
  247. 3 NUMCHARS()=NUMCHARS
  248. 3 NUMPAGES()=NUMPAGES
  249. 3 NUMWORDS()=NUMWORDS
  250. 3 PAGE()=PAGE
  251. 3 PRINTDATE()=PRINTDATE
  252. 3 REVNUM( )=REVNUM
  253. 3 SAVEDATE()=SAVEDATE
  254. 3 SUBJECT()=SUBJECT
  255. 3 TITLE()=TITLE
  256. 2 Remote functions
  257. 3 Remote functions=Remote_functions
  258. 3 DBFIELDCOUNT(database, source)=DBFIELDCOUNT_database_source
  259. 3 DBFIELDNAME(database, source, index)=DBFIELDNAME_database_source_index
  260. 3 DBFILTER(database, table, filter, field_name, rec_num)=DBFILTER_database_table_filter_field_name_rec_num
  261. 3 DBFILTERSORT(database, table, filter, sort, field_name, rec_num)=DBFILTERSORT_database_table_filter_sort_field_name_rec_num
  262. 3 DBGET(database, source, field_name, rec_num)=DBGET_database_source_field_name_rec_num
  263. 3 DBQUERYCOUNT(database)=DBQUERYCOUNT_database
  264. 3 DBQUERYNAME(database, index)=DBQUERYNAME_database_index
  265. 3 DBRELATIONCOUNT(database)=DBRELATIONCOUNT_database
  266. 3 DBRELATIONNAME(database, index)=DBRELATIONNAME_database_index
  267. 3 DBSORT(database, table, sort, field_name, rec_num)=DBSORT_database_table_sort_field_name_rec_num
  268. 3 DBSQL(database, SQL_statement, field_name, rec_num)=DBSQL_database_SQL_statement_field_name_rec_num
  269. 3 DBSQLFILTER(database, table, filter, field_name, rec_num)=DBSQLFILTER_database_table_filter_field_name_rec_num
  270. 3 DBSQLSORT(database, table, sort, field_name, rec_num)=DBSQLSORT_database_table_sort_field_name_rec_num
  271. 3 DBSQLFILTERSORT(database, table, filter, sort, field_name, rec_num)=DBSQLFILTERSORT_database_table_filter_sort_field_name_rec_num
  272. 3 DBTABLECOUNT(database)=DBTABLECOUNT_database
  273. 3 DBTABLENAME(database, index)=DBTABLENAME_database_index
  274. 3 HYPERLINK(link location, friendly name)=HYPERLINK_link_location_friendly_name
  275. 3 REMOTE(document_name, reference_name)=REMOTE_document_name_reference_name
  276. 3 SSGET(spreadsheet, reference)=SSGET_spreadsheet_reference
  277. 3 WPGET(document, fieldname)=WPGET_document_fieldname
  278.