How to Use Excel SMALL Function in Office 365? – (with Examples)
Tags: excelfunctions, excelsmallfunctionin
Published: 2020-09-04 12:23:16

---
title: How to Use Excel SMALL Function in Office 365? – (with Examples)
published: true
date: 2020-09-04 08:33:36 UTC
tags: ExcelFunctions,ExcelSMALLFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/
---

## Excel SMALL Function:

![SMALL Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_jtWCg5l7nF.png)<figcaption id="caption-attachment-13368">SMALL Function</figcaption>

In this article, you will learn how to use **Excel SMALL Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)



## **SMALL Function – Explanation:**

- This function returns the **N<sup>th</sup>**  **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.

## **Syntax:**

**=SMALL(array, n)**

### Parameters Description:

- **Array ** – The array or range of inputs from which you want to find the **N<sup>th</sup>**  **smallest value.**
- **n** – The position ( **N<sup>th</sup>**  **smallest** ) in the array or range that you want to be returned.
- For example, **SMALL(B2:B6, 1)** will return the **1<sup>st</sup>** least value from the range of cells, **SMALL(B2:B6, 2)** will return the **2<sup>nd</sup>** least value from the range.

### Note:

- If the array is empty and then returns [**#NUM!**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) Error value.
- If the argument n is less than 0 or greater than the number of input elements, then it returns the[**#NUM!**  **Error value**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

## **Examples:**

Let’s see some examples to make it clear.

### Example 1:

- Kindly, refer to the below screenshot.
- You can see the range of **input** values in **Column B** and the  **N<sup>th</sup>**  **smallest values** in **Column E.**

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-19.png)<figcaption id="caption-attachment-13359">Example 1</figcaption>

### Example 2:

- If the array is empty and then returns [**#NUM!** Error value](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the argument n is less than 0 or greater than the number of input elements, then it returns the[**#NUM!** Error value](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-16.png)<figcaption id="caption-attachment-13361">Example 2</figcaption>

## **A Brief Summary:**

In the above article, you can understand the usage of **Excel SMALL Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Function:

- [**LARGE Function in Excel Office 365**](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)

### Read Also:

- [How to Use Excel MOD Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)
- [How to Use Excel MIN Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)