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