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

Hits: 70 # (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.

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

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

R Machine Learning & Data Science Recipes: Learn by Coding

There are 2000+ End-to-End Python & R Notebooks are available to build Professional Portfolio as a Data Scientist and/or Machine Learning Specialist. All Notebooks are only \$19.95. We would like to request you to have a look at the website for FREE the end-to-end notebooks, and then decide whether you would like to purchase or not.

Please do not waste your valuable time by watching videos, rather use end-to-end (Python and R) recipes from Professional Data Scientists to practice coding, and land the most demandable jobs in the fields of Predictive analytics & AI (Machine Learning and Data Science).

The objective is to guide the developers & analysts to “Learn how to Code” for Applied AI using end-to-end coding solutions, and unlock the world of opportunities!