VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » Geeks Tutorial
How to Calculate the Range in Excel

How to Calculate the Range in Excel

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
In this tutorial you will learn how to calculate range in Excel. In this tutorial you will learn how to calculate range in Excel. The range is the difference between the highest and the lowest of differences in a series of numbers. We will therefore need the series that we want to perform range function upon. Let's create it: Prerequisites: Microsoft Excel. Step 1. Launch Excel and start a new file from File- New. Step 2. Fill several rows with the values you want to calculate the range for. At the bottom of the column, type the following formula =MAX (Axx: Ayy, where Axx and Ayy are the starting, and the ending cells of your data, respectively. Near the previous cell, type the following formula =MIN(Axx: Ayy, where Axx and Ayy are the starting, and the ending cells of your data, respectively. Step 3. Now go to the place where you want to have your range displayed. Enter the formula =X-Y, where X and Y are the first and the second cells calculated. Hit Enter. Excel will update your cell with the result. Result: Congratulations, you have learnt how to calculate the range in Excel
Date: 2023-07-08

Comments and reviews: 4


say for example A10 - B10 not ayy or x or y. this is Y people hate math. How much longer does it take to say something in order to make it clear. but at least I found the formula so thank you
reply

Hello, How can I calculate a sequence starting with a negative number as 0%, 25%, 50%, 75% and 100%. For example, -10, 0, 10, 20, 30, 40
reply

you can also just skip typing in the column letter and numbers you want to use and highlight them and then press enter
reply

could you not say respectably ever 10 seconds I felt like I was gonna stick a toothpick through my eardrum
reply
Add a review, comment






Other channel videos