Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
While the tie method is correct, you might be trying to sort with a formula. If
subsequent VLOOKUP formulas will be attempting to pull every name from the
list, those VLOOKUP formulas will be expecting there to be a #3 ranking. In
this case, force the later occurrence of rank #2 to appear as #3 by adding a
COUNTIF function to count how many times this score has previously appeared
in the list. Note the severely mixed reference as the second argument of the
COUNTIF: The row number of the heading is frozen with a dollar sign, but the
last cell in the range is a relative reference pointing to the row above the current
formula.
RATE(nper,pmt,pv,fv,type,guess) [Category: Financial]
Returns the interest rate per period of an annuity. RATE is calculated by iteration
and can have zero or more solutions. If the successive results of RATE do not
converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error
value.
RECEIVED(settlement,maturity,investment,discount,basis) [Category:
Financial]*
Returns the amount received at maturity for a fully invested security.
REGISTER.ID(fi le_text,resource,type_text)
Returns the register ID of the specifi ed dynamic link library (DLL) or code
resource that has been previously registered. If the DLL or code resource has
not been registered, this function registers the DLL or code resource and then
returns the register ID for the Macintosh.
REGISTER.ID(module_text,procedure,type_text)
Returns the register ID of the specifi ed dynamic link library (DLL) or code
resource that has been previously registered. If the DLL or code resource has
 
Search JabSto ::




Custom Search