Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

cash. For example, you can use EXPONDIST to determine the probability that

the process takes at most 1 minute.

FACT(number) [Category: Math]

Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...*

number.

FACTDOUBLE(number) [Category: Math]*

Returns the double factorial of a number. Guru Tip: The double factorial of a

number is the product of every other number. For example, the double factorial of

9 is 9 x 7 x 5 x 3 x 1. It is fairly difﬁ cult to ﬁ nd real-life examples for this function. It

does something mathematically interesting when you chart the double factorial

from -2 to -1, but Excel won’t calculate double factorial for negative numbers.

So – the two examples that I have found: used to calculate the number of

permutations of the ﬁ ve-card board that can be dealt in a game of Texas Hold-

em (the formula involved the FACTDOUBLE of the number of players sitting at

the table) and the number of games in a round-robin tennis match.

FALSE( ) [Category: Logical]

Returns the logical value FALSE. Guru Tip: This seems redundant. Any place

where I might want to use =FALSE(), I could simply type FALSE. Am I missing

something?

FDIST(x,degrees_freedom1,degrees_freedom2) [Category: Statistical]]

Returns the F probability distribution. You can use this function to determine

whether two data sets have different degrees of diversity. For example, you

can examine test scores given to men and women entering high school and

determine if the variability in the females is different from that found in the

males.

FIND(ﬁ nd_text,within_text,start_num) [Category: Text]

FIND ﬁ nds one text string (ﬁ nd_text) within another text string (within_text), and

returns the number of the starting position of ﬁ nd_text, from the ﬁ rst character of

within_text. You can also use SEARCH to ﬁ nd one text string within another, but

unlike SEARCH, FIND is case sensitive and doesn’t allow wildcard characters.

Guru Tip: I frequently use FIND when I need to categorize data. For example,

say I have 800 rows of data and each record contains a paragraph of description

for an episode of the MrExcel podcast. A formula of =FIND("pivot",lower(D2))

will mostly return a #VALUE! error. (ﬁ rst ﬁ gure below) However, sort the FIND

column ascending and all of the episodes which mention a pivot will sort to the

top. (second ﬁ gure below).