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
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 returns the largest numeric value from the range of input values.
- MIN – MIN Function 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.
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.
{=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)(C5:C12-D5:D12)}
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.
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.
{=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(C5:C12-D5:D12)}
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.
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!! *And Excel Formulas *!!
Related Articles:
Top comments (0)