MAX Function
The MAX function is a premade function in Google Sheets, which finds the highest number in a range.
It is typed =MAX
and gets a list of cells:
=MAX(value1, [value2, ...])
You can select cells one by one, but also ranges, or even multiple ranges.
The function ignores cells with text. It will only work for cells with numbers.
Note: There is another function called =MIN
, which finds the lowest value in a range, the opposite of MAX.
Let's have a look at an example!
Max Function Example
Find the highest total stats in the range C2:C21
:
Copy Values
- Select the cell (
F3
) - Type
=MAX
- Click the MAX command
- Specify the range
C2:C21
for the Total stats values - Hit enter
Now, the function returns the highest value from the cells in the range:
That's great! The function has successfully found the highest value, 525
. Cloyster has the highest Total stats of the Pokemons in this list.
Let's add text to a cell in the range C2:C21
to see what happens. Type Alakazam to into the cell C8
:
Nice going. The function ignores the text typed in the range. 510
is returned as the new highest value, since the old one was replaced with text. Poliwrath is now the Pokemon with the highest Total stats in the range C2:C21
.
W3schools Pathfinder
Track your progress - it's free!
FAQs
Both My Learning and W3Schools Public Profile are completely free of charge, however there are available upgrade plans that can enhance your learning experience. Where can I find My Learning? You can access your My Learning profile through the upper right corner on any W3Schools page.
Why do people avoid W3Schools? ›
Their examples are outdated, insecure, and don't really explain why things work in a certain way. Their tutorials are optimized for copy & paste, and God knows how many security bugs in the wild are due to somebody copying W3Schools.
Is W3Schools certification legit? ›
W3Schools is Trusted by Top Companies
Our certificates are recognized and valued by companies looking to employ skilled developers.
Is W3Schools a good website? ›
W3schools is a great resource for looking up how to write a specific piece of code, but it doesn't have the flow or continuity that the other courses do. Basically, as others keep mentioning, W3schools is good for syntax, but it doesn't really teach you to think like a developer.
What is W3Schools used for? ›
W3Schools is a freemium educational website for learning coding online. Initially released in 1998, it derives its name from the World Wide Web but is not affiliated with the W3 Consortium. W3Schools offers courses covering many aspects of web development. W3Schools also publishes free HTML templates.
Can I get a job with W3Schools certificate? ›
Becoming certified by W3Schools is great proof to show to employers and makes your resume stand out among other candidates.
How does w3school make money? ›
Through ads : through ads alone they will earn alot in w3schools. They would earn nearly 1–2lacks per day in ads alone. Through donation:. Many people who completed their courses in w3schools, after few years , they would donate some money for the growth of the site .
Which is better W3Schools or codecademy? ›
Of the two, Codecademy has a simpler structure. You can easily find the topic you want and start learning. Its fixed pricing plans are also easier to understand. In addition, the biggest issue with W3Schools is the ads that keep popping up as you learn.
How long does W3Schools take? ›
W3Schools is a tech training provider offering a 24-week, part-time, live online, Web Development Bootcamp.
Why is it called W3Schools? ›
W3Schools was created in 1998, and derives its name from the World Wide Web (WWW) but is not affiliated with the W3C.
The Most Popular Browsers
W3Schools has over 60 million monthly visits.
Is W3Schools a bootcamp? ›
Live Online Bootcamp
In this mini bootcamp, you will learn how to use Python, which is one of the most powerful languages in the world of Data Science.
Is W3 free to use? ›
W3. CSS is free to use. No license is necessary.
Is W3Schools space free? ›
Getting started with Spaces is straightforward: simply sign up for an account to begin with a Free subscription, which requires no payment.
Does W3Schools cover everything? ›
W3Schools is a school for web developers, covering all the aspects of web development: HTML Tutorial. CSS Tutorial. JavaScript Tutorial.