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.