Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
(A2,MyTable,2,False)). If you’ve upgraded to Excel 2007 and everyone who
might open your workbook has upgraded to Excel 2007, check out the new
IFERROR function instead.
ISNONTEXT(value) [Category: Information]
Returns TRUE if Value refers to any item that is not text. (Note that this function
returns TRUE if value refers to a blank cell.)
ISNUMBER(value) [Category: Information]
Returns TRUE if Value refers to a number.
ISODD(number) [Category: Information]*
Returns TRUE if number is odd, or FALSE if number is even. Guru Tip: You
could also use =MOD(Number,2)=1 to replace this function.
ISPMT(rate,per,nper,pv) [Category: Financial]
Calculates the interest paid during a speciﬁ c period of an investment. This
function is provided for compatibility with Lotus 1-2-3.
ISREF(value) [Category: Information]
Returns TRUE if Value refers to a reference. Guru Tip: If you don’t want your
INDIRECT functions to return errors, you can check to see if it is a reference
with ISREF ﬁ rst.
ISTEXT(value) [Category: Information]
Returns TRUE if Value refers to text.
JIS(text) [Category: Text]
Changes half-width (single-byte) English letters or katakana within a character
string to full-width (double-byte) characters.
KURT(number1,number2, ...) [Category: Statistical]]
Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness
or ﬂ atness of a distribution compared with the normal distribution. Positive
kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a
relatively ﬂ at distribution.
LARGE(array,k) [Category: Statistical]]
Returns the k-th largest value in a data set. You can use this function to select a
value based on its relative standing. For example, you can use LARGE to return
the highest, runner-up, or third-place score. Guru Tip: while =MAX returns the
largest value, =LARGE(range,2) will return the 2nd largest value. Great for
throwing out outliers. Also see PERCENTILE. Also see page 49.
LCM(number1,number2, ...) [Category: Math]*
Returns the least common multiple of integers. The least common multiple is
the smallest positive integer that is a multiple of all integer arguments number1,
number2, and so on. Use LCM to add fractions with different denominators.