Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

HOUR(serial_number) [Category: Date & Time]

Returns the hour of a time value. The hour is given as an integer, ranging from

0 (12:00 A.M.) to 23 (11:00 P.M.).

HYPERLINK(link_location,friendly_name) [Category: Lookup &

Reference]

Creates a shortcut or jump that opens a document stored on a network server,

an intranet, or the Internet. When you click the cell that contains the HYPERLINK

function, Microsoft Excel opens the ﬁ le stored at link_location. Guru Tip: These

hyperlinks are not as good as the ones created by the Insert Hyperlink dialog.

Yes, I understand that you are using this function because you have the web

page URL right over there in column C. If you want to add a bunch of hyperlinks,

select the range where the hyperlinks to be and run this three line macro:

Sub AddRealHyperlinks()

For Each cell In Selection

ActiveSheet.Hyperlinks.Add Anchor:=cell, Address:=cell.Offset(0, 1).Value

Next cell

End Sub

HYPGEOMDIST(sample_s,number_sample,population_s,number_

population) [Category: Statistical]]

Returns the hypergeometric distribution. HYPGEOMDIST returns the probability

of a given number of sample successes, given the sample size, population

successes, and population size. Use HYPGEOMDIST for problems with a ﬁ nite

population, where each observation is either a success or a failure, and where

each subset of a given size is chosen with equal likelihood.

IF(logical_test,value_if_true,value_if_false) [Category: Logical]

Returns one value if a condition you specify evaluates to TRUE and another

value if it evaluates to FALSE. Guru Tip: To make this function more powerful,

replace the logical_test argument with a combination of AND, OR, NOT functions.

See page 17

IFERROR(value,value_if_error) [Category: Logical]

Returns a value you specify if a formula evaluates to an error; otherwise, returns

the result of the formula. New in Excel 2007. Use the IFERROR function to trap

and handle errors in a formula. Guru Tip: IFERROR is designed to speed your