Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

can’t specify that lower scores are better, although you could subtract the result

from 100% to reverse the sequence. If signiﬁ cance is omitted, a value of 3 is

used, meaning that the result will contain 3 signiﬁ cant digts. A result of 0.123 will

appear at 12.3% when properly formatted as a percentage.

PERMUT(number,number_chosen) [Category: Statistical]]

Returns the number of permutations for a given number of objects that can be

selected from number objects. A permutation is any set or subset of objects

or events where internal order is signiﬁ cant. Permutations are different from

combinations, for which the internal order is not signiﬁ cant. Guru Tip: Use

COMBIN for lottery probabilities where the order of the numbers drawn does

not matter. Use PERMUT when the order of the results matter. To ﬁ nd out how

many possible ways that 8 greyhounds can ﬁ nish in ﬁ rst-second-third, use

=PERMUT(8,3).

PHONETIC(reference) [Category: Text]

Extracts the phonetic (furigana) characters from a text string.

PI( ) [Category: Math]

Returns the number 3.14159265358979, the mathematical constant pi, accurate

to 15 digits. Guru Tip: Useful for ﬁ guring out which pizza deal is best for the

ofﬁ ce staff meeting. The area of a circle is PI()*Radius^2. A 16" pie has a radius

of 8" and contains 201 square inches of piizza. A 12" pie has a radius of 6" and

contains 113 square inches of pizza. To compare these round pizzas to square

pizzas, see SQRTPI.