Sometimes, we want to get the smallest value from the range. Doing this manually will take a long time. But, you can do this with a few clicks using the Excel feature called “SMALL Function.” Using this built-in function, you can get the n the smallest value from the given range. It is really easy to use.
In this article, you will learn how to use Excel SMALL Function with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of MS Excel from the following link:
Explanation of SMALL Function
- It is one of the built-in functions in Microsoft Excel.
- This function returns the Nth smallest value from the given range of data.
- For example, you can find the smallest value from the range or second-smallest value, or third-smallest value using this function.
- Here, you will see the syntax of the SMALL function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
- Array – The array or range of inputs from which you want to find the Nth smallest value.
- n – The position ( Nth smallest ) in the array or range that you want to be returned.
- For example, SMALL(B2:B6, 1) will return the 1st least value from the range of cells, and SMALL(B2:B6, 2) will return the 2nd least value from the range.
1) If the array is empty and then returns #NUM! Error value.
2) If the argument n is less than 0 or greater than the number of input elements, then it returns the #NUM! Error value.
Let’s see some examples to make it clear how to apply the SMALL function in Excel.
- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- For example, we have shown you a range of student’s marks in the following image. From which, we will find the first and second-smallest values using the SMALL function.
- Now, we need to enter the above-mentioned formula to get the result.
- After entering the formula, you need to click the Enter button to get the output, as shown below.
Input that Causes Error
- As we said earlier, If the argument n is less than 0 or greater than the number of input elements, then it returns the #NUM! Error value.
A Brief Summary
In the above article, you can understand the usage of the Excel SMALL Function in Office 365 with its syntax, explanation, and examples. Drop your feedback in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Use the following video to learn how to apply the SMALL Function on your Excel spreadsheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!