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 fi 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
fi 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.
 
Search JabSto ::




Custom Search