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

Search JabSto ::

Custom Search