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.