Author: Oscar Cronquist Article last updated on September 09, 2021

The MAX function allows you to calculate the largest number in a cell range.

The formula in cell D3 extracts the highest number from cell range B3:B10, see picture above.

Excel Function Syntax

MAX(number1, [number2], ...)

Arguments

number1 - You need at least one argument. Required.

[number2] - Up to 254 arguments are possible. Optional.

Comments

Arguments can be constants, named ranges, cell references and arrays.

The MAX function ignores text and boolean values, however not errors.

Table of contents

  1. Excel function not working
  2. Max function with criteria
  3. Max function with multiple criteria
  4. Max function returns 0 (zero)
  5. Max function for text
  6. MAX function ignore #N/A error
    1. What is N/A error?
  7. MAX function second highest
  8. MAX function Conditional formatting

 

1. Excel function not working

2. Max function with criteria

3. Max function with multiple criteria

4. Max function returns 0 (zero)

5. Max function for text

6. MAX function ignore #N/A error

6.1 What is N/A error?

7. MAX function second highest

8. MAX function Conditional formatting