![]() ![]() For this, we will follow the same procedure as we did in the above examples. Now for identifying the span of sales amount in the above dataset, we will calculate the range. Hit enter, and it will give you the maximum value. Range in Excel – Example #2įor finding the maximum value from the dataset, we will apply here the MAX function as below screenshot: Let’s take an example to understand the usage of this function. In this process, two function plays a very important role. ![]() If the dataset is small, it gives you a closely centered result.įor defining the range, we need to find out the maximum and minimum values of the dataset.If the dataset is large, it gives you the widespread of the result.It gave you a visual indication of the range as we are looking for the highest and smallest point. In this above example, the Range is 58 in the given dataset, which defines the span of the dataset.The largest number in the above-given range is 60, and the smallest number is 2. You can download this Find Range Excel Template here – Find Range Excel Template Range in Excel – Example #1 TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |