Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

YEARFRAC(start_date,end_date,basis) [Category: Date & Time]*

Calculates the fraction of the year represented by the number of whole days

between two dates (the start_date and the end_date). Use the YEARFRAC

worksheet function to identify the proportion of a whole year’s beneﬁ ts or

obligations to assign to a speciﬁ c term.

YEN(number,decimals) [Category: Text]

Converts a number to text, using the ¥ (yen) currency format, with the number

rounded to a speciﬁ ed place.

YIELD(settlement,maturity,rate,pr,redemption,frequency,basis)

[Category: Financial]*

Returns the yield on a security that pays periodic interest. Use YIELD to calculate

bond yield.

YIELDDISC(settlement,maturity,pr,redemption,basis) [Category:

Financial]*

Returns the annual yield for a discounted security.

YIELDMAT(settlement,maturity,issue,rate,pr,basis) [Category: Financial]*

Returns the annual yield of a security that pays interest at maturity.

ZTEST(array,x,sigma) [Category: Statistical]]

Returns the two-tailed P-value of a z-test. The z-test generates a standard score

for x with respect to the data set, array, and returns the two-tailed probability for

the normal distribution. You can use this function to assess the likelihood that a

particular observation is drawn from a particular population.