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.