Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
2
Tap or click the
OK button (Insert
Function dialog
box) to display the
Function Arguments
dialog box.
Type b4:b12 in
the Number1 box
(Function Arguments
dialog box) to enter
the rst argument
of the function
(Figure 2 – 16).
Function Arguments
dialog box
range typed in
Number 1 box
rst few numbers
in range
Why did numbers
appear to the right
of the Number 1
box in the Function
Arguments dialog
box?
As shown in
Figure 2 – 16, Excel
displays the value the MAX function will return to cell B14 in the Function Arguments dialog box. It also lists
the rst few numbers in the selected range, next to the Number1 box.
result of function
OK button
Figure 2 – 16
3
Tap or click the OK
button (Function
Arguments dialog
box) to display the
highest value in
the chosen range
in the selected cell
(Figure 2 – 17).
MAX function determines
highest value in range B4:B12
Why should I not just
enter the highest
value that I see in
the range B4:B12 in
cell B14?
In this example,
rather than
entering the MAX
function, you
visually could scan
the range B4:B12,
determine that the
highest number of
dependents is 4, and manually enter the number 4 as a constant in cell B14. Excel would display the number the
same as in Figure 2 – 17. Because it contains a constant, however, Excel will continue to display 4 in cell B14, even if
the values in the range change. If you use the MAX function, Excel will recalculate the highest value in the range
each time a new value is entered into the worksheet.
highest value in range B4:B12
Figure 2 – 17
Other Ways
1. Tap or click Sum arrow (HOME tab | Editing
group), tap or click Max
2. Tap or click Sum arrow (FORMULAS tab |
Function Library group), tap or click Max
3. Type =MAX in cell, fill in arguments
 
Search JabSto ::




Custom Search