Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

PRICE(settlement,maturity,rate,yld,redemption,frequency,basis)

[Category: Financial]*

Returns the price per $100 face value of a security that pays periodic interest.

PRICEDISC(settlement,maturity,discount,redemption,basis) [Category:

Financial]*

Returns the price per $100 face value of a discounted security.

PRICEMAT(settlement,maturity,issue,rate,yld,basis) [Category:

Financial]*

Returns the price per $100 face value of a security that pays interest at

maturity.

PROB(x_range,prob_range,lower_limit,upper_limit) [Category:

Statistical]]

Returns the probability that values in a range are between two limits. If upper_

limit is not supplied, returns the probability that values in x_range are equal to

lower_limit. Guru Tip: Used frequently in statistics. I had an opportunity to use it

once, when I was in a statistics class.

PRODUCT(number1,number2, ...) [Category: Math]

Multiplies all the numbers given as arguments and returns the product.

PROPER(text) [Category: Text]

Capitalizes the ﬁ rst letter in a text string and any other letters in text that follow

any character other than a letter. Converts all other letters to lowercase letters.

Guru Tip: PROPER is great for putting upper case names into proper case.

Although, watch out for names where an interior letter is supposed to be

capitalized. =PROPER("MCCARTNEY") is going to return Mccartney.

PV(rate,nper,pmt,fv,type) [Category: Financial]

Returns the present value of an investment. The present value is the total

amount that a series of future payments is worth now. For example, when you

borrow money, the loan amount is the present value to the lender.

QUARTILE(array,quart) [Category: Statistical]]

Returns the quartile of a data set. Quartiles often are used in sales and survey

data to divide populations into groups. For example, you can use QUARTILE to

ﬁ nd the top 25 percent of incomes in a population.

QUOTIENT(numerator,denominator) [Category: Math]*

Returns the integer portion of a division. Use this function when you want to

discard the remainder of a division. Guru Tip: For the opposite of QUOTIENT,

see MOD.

RADIANS(angle) [Category: Math]

Converts degrees to radians. Guru Tip: See COS.