MAX

Returns the largest value in a set of values.
Syntax
MAX(number1,number2,...)
Number1, number2, ...    are 1 to 30 numbers for which you want to find the maximum value.
Remarks

• You can specify arguments that are numbers, empty cells, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause errors.
• If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored. If logical values and text must not be ignored, use MAXA instead.
• If the arguments contain no numbers, MAX returns 0 (zero).

Example
The example may be easier to understand if you copy it to a blank worksheet.

	A
1	Data
2	10
3	7
4	9
5	27
6	2

Formula	Description (Result)
=MAX(A2:A6)	Largest of the numbers above (27)
=MAX(A2:A6, 30)	Largest of the numbers above and 30 (30)

COUNT

Counts the number of cells that contain numbers and also numbers within the list of arguments. Use COUNT to get the number of entries in a number field that's in a range or array of numbers.
Syntax
COUNT(value1,value2,...)
Value1, value2, ...    are 1 to 30 arguments that can contain or refer to a variety of different types of data, but only numbers are counted.
Remarks

• Arguments that are numbers, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.
• If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored. If you need to count logical values, text, or error values, use the COUNTA function.

Example

HYPERLINK

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 file stored at link_location.

Syntax
HYPERLINK(link_location,friendly_name)

Link_location is the path and file name to the document to be opened as text. Link_location can refer to a place in a document— such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet.

· Link_location can be a text string enclosed in quotation marks or a cell that contains the link as a text string.

· If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.

Friendly_name is the jump text or numeric value that is displayed in the cell. Friendly_name is displayed in blue and is underlined. If friendly_name is omitted, the cell displays the link_location as the jump text.

· Friendly_name can be a value, a text string, a name, or a cell that contains the jump text or value.

· If friendly_name returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.

Remark
To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross (+), then release the mouse button.
Examples