In Excel an Array Formula allows you to do powerful calculations on one or more value sets. An array is just a list or range of values but an Array Formula is a special type of formula that must be entered by pressing Ctrl Shift Enter. While entering Array formula you need to press Ctrl Shift Enter Excel add curly brackets The array formula returns the total commision in single cell In this example the formula multiplies the corresponding values in two arrays and creates a new array in Excel Memory.
Release the Ctrl and Shift keys.
The result may fit in a single cell or it may be an array. How to enter an array formula CTRLSHIFTENTER How to evaluate portions of an array formula F9 key Single-cell and multi-cell array formulas in Excel. They all begin with an equal sign and you can use most of the built-in Excel functions in your array formulas. To find the greatest progress dont be overwhelmed we add the MAX function replace C2 with C2C6 and B2 with.