Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
something actually useful for N, I am not sure why you would want to wipe out
all the numbers in a range.
TAN(number) [Category: Math]
Returns the tangent of the given angle.
TANH(number) [Category: Math]
Returns the hyperbolic tangent of a number.
TBILLEQ(settlement,maturity,discount) [Category: Financial]*
Returns the bond-equivalent yield for a Treasury bill.
TBILLPRICE(settlement,maturity,discount) [Category: Financial]*
Returns the price per $100 face value for a Treasury bill.
TBILLYIELD(settlement,maturity,pr) [Category: Financial]*
Returns the yield for a Treasury bill.
TDIST(x,degrees_freedom,tails) [Category: Statistical]]
Returns the Percentage Points (probability) for the Student t-distribution where
a numeric value (x) is a calculated value of t for which the Percentage Points
are to be computed. The t-distribution is used in the hypothesis testing of small
sample data sets. Use this function in place of a table of critical values for the
TEXT(value,format_text) [Category: Text]
Converts a value to text in a speciﬁ c number format. Guru Tip: This is very
useful when you are joining text and a date or text and currency. To ensure that
the currency shows up with two decimal places and a comma, use ="Please
remit "&TEXT(F20,"$#,##0.00"). See page 35
TIME(hour,minute,second) [Category: Date & Time]
Returns the decimal number for a particular time. The decimal number returned
by TIME is a value ranging from 0 to 0.99999999, representing the times from
0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.). Guru Tip: Say that you
have someone who entered a column of times. They entered 2:30 thinking
that it meant 2 minutes and 30 seconds, but Excel interpreted it as 30 minutes
past two o’clock. To convert that column back to something usable, the formula
=TIME(0,HOUR(A2),MINUTE(A2)) would do the trick.
TIMEVALUE(time_text) [Category: Date & Time]
Returns the decimal number of the time represented by a text string. The
decimal number is a value ranging from 0 (zero) to 0.99999999, representing
the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.). Guru Tip:
Like DATEVALUE, this function is used to convert a range of text that looks like
times to real times. After converting the values, apply a time format to get the
results to look like times instead of decimals. The advantage, of course, is that
you can now do time calculations on the real times.