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