Hits: 51

# (Excel examples for Beginners)

In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Larger of two values in Excel.

## Excel formula for Beginners – How to find Larger of two values in Excel

### Generic formula

=MAX(value1,value2)

### Summary

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)

### Explanation

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.

### 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.

## Excel formula for Beginners – How to find Larger of two values in Excel

#### Free Machine Learning & Data Science Coding Tutorials in Python & R for Beginners. Subscribe @ Western Australian Center for Applied Machine Learning & Data Science.

Western Australian Center for Applied Machine Learning & Data Science – Membership

## Sign up to get end-to-end “Learn By Coding” example.

**Introduction to Applied Machine Learning & Data Science for Beginners, Business Analysts, Students, Researchers and Freelancers with Python & R Codes @ Western Australian Center for Applied Machine Learning & Data Science (WACAMLDS) !!!**

Latest end-to-end Learn by Coding Projects (Jupyter Notebooks) in Python and R:

**Applied Statistics with R for Beginners and Business Professionals**

**Data Science and Machine Learning Projects in Python: Tabular Data Analytics**

**Data Science and Machine Learning Projects in R: Tabular Data Analytics**

**Python Machine Learning & Data Science Recipes: Learn by Coding**