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

Lookup and Reference Examples

  • How to use Excel MMULT Function
  • How to get relative column numbers in a range in Excel
  • Extract data with helper column in Excel
  • How to get address of first cell in range in Excel
  • Create hyperlink with VLOOKUP in Excel

Data Analysis Examples

  • How To Remove Duplicates In Excel Column Or Row?
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Subtotal function in Excel
  • How to calculate current stock or inventory in Excel

Data Validation Examples

  • Data validation must not exist in list
  • Excel Data validation only dates between
  • Excel Data validation date in specific year
  • Excel Data validation specific characters only
  • Excel Data validation exists in list

Larger of two values in Excel

by

This tutorial shows how to calculate Larger of two values in Excel using the example below;

Formula

=MAX(value1,value2)

Explanation

To get the larger, or greater, of two values, you can use the MAX function. In the example shown, the formula in D5 is:

=MAX(B5,C5)

How this formula works

The MAX function is fully automatic – it returns the largest value in the numbers provided. In this case, we give MAX function two values:

=MAX(B5,C5)

and MAX returns the larger value.

Worked Example:   Calculate shipping cost with VLOOKUP in Excel

Elegant alternative to IF

The MAX function can be a compact and elegant replacement for the IF function. For example, the formula above can be written with IF like so:

=IF(B5>=C5,B5,C5)

However, the MAX version is 6 characters shorter (11 vs. 17), and contains no redundant references, so it is less prone to errors.

Worked Example:   nth largest value with duplicates in Excel
Worked Example:   Calculate cap percentage at specific amount in Excel

Post navigation

Previous Post:

Max of every nth column in Excel

Next Post:

Large with criteria 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 extract substring in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • Excel MAX, MATCH and ADDRESS function illustration
  • Replace one character with another in Excel
  • How to extract last two words from text string in Excel
  • Convert decimal minutes to Excel time
  • Get first day of previous month in Excel
  • How to calculate Next working/business day in Excel
  • Sum race time splits in Excel
  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment for a loan in Excel
  • How to calculate present value of annuity in excel
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate annual compound interest schedule in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles