Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

irregular spacing. Guru Tip: If your VLOOKUP functions are not working, check

to see if one list has extra spaces at the end of the value. =TRIM(" ABC DEF

") will return "ABC DEF". TRIM removes leading spaces, trailing spaces and

replaces multiple interior spaces with a single space. See page 120.

TRIMMEAN(array,percent) [Category: Statistical]]

Returns the mean of the interior of a data set. TRIMMEAN calculates the mean

taken by excluding a percentage of data points from the top and bottom tails of

a data set. You can use this function when you wish to exclude outlying data

from your analysis.

TRUE( ) [Category: Logical]

Returns the logical value TRUE. Guru Tip: See FALSE().

TRUNC(number,num_digits) [Category: Math]

Truncates a number to an integer by removing the fractional part of the number.

Guru Tip: For positive numbers, INT and TRUNC operate the same. However,

for negative numbers, TRUNC will move towards zero and INT will move away

from zero. As you see in this image, the INT(-1.6) is -2, while TRUNC(-1.6) is

-1

TTEST(array1,array2,tails,type) [Category: Statistical]]

Returns the probability associated with a Studentâ€™s t-Test. Use TTEST to

determine whether two samples are likely to have come from the same two

underlying populations that have the same mean.

TYPE(value) [Category: Information]

Returns the type of value. Use TYPE when the behavior of another function

depends on the type of value in a particular cell. Guru Tip: Type returns 1 for

numbers, 2 for text, 4 for TRUE and FALSE, 16 for errors, and 64 for an array.

UPPER(text) [Category: Text]

Converts text to uppercase. Guru Tip: Perfect for converting lower case text to

upper case to facilitate matching two lists. Also see PROPER and LOWER.