Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2,…])
[Category: Math]
Applies criteria to cells across multiple ranges and counts the number of times
all criteria are met. Added in Excel 2007. Guru Tip: This is the plural version of
COUNTIF.You can specify up to 127 pairs of criteria range and criteria.
COUPDAYBS(settlement,maturity,frequency,basis) [Category: Financial]*
Returns the number of days from the beginning of the coupon period to the
settlement date.
COUPDAYS(settlement,maturity,frequency,basis) [Category: Financial]*
Returns the number of days in the coupon period that contains the settlement
date.
COUPDAYSNC(settlement,maturity,frequency,basis) [Category:
Financial]*
Returns the number of days from the settlement date to the next coupon date.
COUPNCD(settlement,maturity,frequency,basis) [Category: Financial]*
Returns a number that represents the next coupon date after the settlement
date. To view the number as a date, click Cells on the Format menu, click Date
in the Category box, and then click a date format in the Type box.
COUPNUM(settlement,maturity,frequency,basis) [Category: Financial]*
Returns the number of coupons payable between the settlement date and
maturity date, rounded up to the nearest whole coupon.
COUPPCD(settlement,maturity,frequency,basis) [Category: Financial]*
Returns a number that represents the previous coupon date before the settlement
date. To view the number as a date, click Cells on the Format menu, click Date
in the Category box, and then click a date format in the Type box.
COVAR(array1,array2) [Category: Statistical]]
Returns covariance, the average of the products of deviations for each data
point pair. Use covariance to determine the relationship between two data sets.
For example, you can examine whether greater income accompanies greater
levels of education.
CRITBINOM(trials,probability_s,alpha) [Category: Statistical]]
Returns the smallest value for which the cumulative binomial distribution is
greater than or equal to a criterion value. Use this function for quality assurance
applications. For example, use CRITBINOM to determine the greatest number
of defective parts that are allowed to come off an assembly line run without
rejecting the entire lot.
 
Search JabSto ::




Custom Search