Few Excel users know about array formulas and I believe they have found themselves in a situation where they need them at least once. They were mentioned in one of the previous “recipes”, and here you will be able to learn how to use them in combination with constants. Constants are values inside curly braces, separated by a comma (or semicolon), and we use them for arithmetic operations within an array formula.
Excel supports a special type of formulas that allows us to use arrays of variables as arguments rather than variables (references, ranges, names), where we can perform certain mathematical operations over all of them. Moreover, there is a situation where the arrays considerably shorten the way to the solution or are even necessary to get to it. In the following text, through a few examples, it will be shown how to use array formulas.