Explanation:

Multiple calculations can be made in a single formula using Array formula.
An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. ... You can use array formulas to perform complex tasks, such as: Quickly create sample datasets.