Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 3

Averages, MIN, MAX and ROUND in Excel

Find the average, the lowest and highest value, round results and pick the top scores.

  1. The average: AVERAGE. AVERAGE adds up the numbers in a range and divides by how many there are. Work out the average customer rating in B7
  2. Lowest and highest: MIN and MAX. MAX returns the highest number in a range, and MIN the lowest. Find the highest temperature of the week, in B9
  3. Round to whole numbers: ROUND. ROUND rounds a number to the number of decimals you choose. It changes the value itself, not just how it looks. Round the price in B2 to two decimals, in C2
  4. ROUND or formatting?.
  5. Top scores: LARGE. LARGE returns the largest value but one, two or more down the list: 1 is the highest, 2 the second highest. Find the second-highest sales figure, in D2
  6. Your turn: an average. AVERAGE adds up the scores and divides by how many there are, in one go. Work out the average test score in D2

← All lessons