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 &
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:
For Each cell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=cell, Address:=cell.Offset(0, 1).Value
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