Microsoft Office Tutorials and References
In Depth Information
(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 specifi 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 fi 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 fl atness of a distribution compared with the normal distribution. Positive
kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a
relatively fl 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.
Search JabSto ::

Custom Search