Excel Formulas to calculate Basic array formula in excel!!
Tags: excelformula, excelformulas
Published: 2021-11-12 07:59:03

---
title: Excel Formulas to calculate Basic array formula in excel!!
published: true
date: 2021-11-09 04:59:09 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-basic-array-formula-in-excel/
---

Before entering this article, you need to know some basic formulas. Here, if you want to use a Basic Array Formula in Excel, what would you do? You are in the right place, we will help you with simple formulas to  **calculate basic array formulas ** in Excel 365. Follow the below-given formulas!! 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)

## Generic Formula

- To use a basic array formulas, you need to use the below given formula.

```
{=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)(rng1-rng2)}

```

## Syntax Explanation

- **Minus Operator (-) –** This symbol will help to subtract any two values.
- **Parenthesis () –** The main purpose of this symbol is to group the elements.
- **Rng 1 –** It represents the first input range in the Excel sheet.
- **Rng 2 –** This will refer to the second input range.
- **MAX** – **[MAX Function](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)** returns the largest numeric value from the range of input values.
- **MIN** **– [MIN Function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)** returns the smallest numeric value from the range of input values.

## Practical Examples

Use the following steps for basic array formulas in Excel.

- In the following example, you have to create a **sample data**  in Microsoft Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-72.png)
_Sample data_

- Then, to count the **max change** in a set of data, you need to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
{=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)(C5:C12-D5:D12)}

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-23.png)
_Use the Formula_

- Now, after pressing **Ctrl+Shift+Enter key,** you will get the result for the MAX in the  **cell G6 ** as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-for-MAX.png)
_Result for MAX_

- After that, to count the **min change** in a set of data, you need to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
{=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(C5:C12-D5:D12)}

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-Formula-1-1.png)
_Use the Formula_

- Finally, after pressing **Ctrl+Shift+Enter key,** you will get the result for the MIN in the  **cell G7 ** as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-for-MIN.png)
_Result for MIN_

## A Brief Synopsis

This article gives you complete information about the ** ** simple formulas to  **calculate basic array formulas ** in Excel 365. Hope that this article is useful to you. Don’t forget to share your valuable  **feedback**  in the below section. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Excel Formulas to Convert the String into Array ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-convert-the-string-into-array/)**
- **[How to Create an Array of Numbers in Excel Office 365?](https://geekexcel.com/how-to-create-an-array-of-numbers-in-excel-office-365/)**
- **[Excel INDEX Function in Office 365 – How to use it?](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**
- **[How to Create VBA Function to Return Array in Excel VBA?](https://geekexcel.com/how-to-create-vba-function-to-return-array-in-excel-vba/)**
- **[How To Mail Sheet using Array VBA in Microsoft Excel?](https://geekexcel.com/how-to-mail-sheet-using-array-vba-in-microsoft-excel/)**