Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Convert text string to valid reference in Excel using Indirect function
  • Last row number in range
  • How to use Excel VLOOKUP Function
  • Multi-criteria lookup and transpose in Excel
  • How to reference named range different sheet in Excel

Data Analysis Examples

  • Create Scatter Chart in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Reverse List in Excel
  • How to Create Area Chart in Excel

Data Validation Examples

  • Excel Data validation require unique number
  • Excel Data validation number multiple 100
  • Excel Data validation must contain specific text
  • Excel Data validation only dates between
  • Excel Data validation must not contain

Maximum value in Excel

by

This tutorial shows how to calculate Maximum value in Excel using the example below;

Formula

=MAX(range)

Explanation

To get the maximum value from a set of numbers, use the MAX function.

Worked Example:   MAX function: Description, Usage, Syntax, Examples and Explanation

In the example shown, the formula in cell I6 is:

=MAX(C6:G6)

The MAX function is fully automatic. It accepts one or more arguments, which can be numbers or cell references that point to numbers, then returns the maximum value.

Post navigation

Previous Post:

Maximum if multiple criteria in Excel

Next Post:

Maximum value if in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count specific characters in a range in Excel
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • How to extract word containing specific text in Excel
  • How to add a line break with a formula while joining text strings in Excel
  • How to check if cell contains number in Excel
  • Convert Excel time to decimal minutes
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate days remaining in Excel
  • Add decimal minutes to time in Excel
  • Next biweekly payday from date in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYS function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles