How to Use Cell Ranges in Excel Formulas

Video Transcript

"Hi, I'm Amar Enhsaihan, I'm going to show you now how to use name ranges in Excel formulas. Here in my example I have these values which are numbers. I'm going to name them. I'm going to highlight the range and then here, I'm going to type the name. I'm going to name it as year 1, year 1 and then click enter. And now you have a range that's called year 1. How do I know? I highlight it and it says right there, year 1. I can also use this information in the formula. Let's say I want to know the sum of the year 1. I'm going to click equal, sum, open and then type in year 1, close it, and I have 485, which is suppose to be the sum of the year 1. In here, we can check using sum function that it is indeed 485. So it is working. You can also name a single cell as something else. So here I highlight the cell and I name it as increase. So if, first year in A location, had a rate of 40 and it increase by 110% or increase by 10%, then we would just use this cell of reference times increase and then we have 44 which is the correct value. If we took 40 and multiply it by 110, then we would get 44. So that's how you name cells and ranges in Excel and use them in formulas. I'm Amar Enhsaihan, thank you for watching."