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*...*
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
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
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).