Array Formulas Require Conditional Formatting

Array formulas are powerful "super-formulas." At MrExcel.com, I call these CSE formulas, because you have to use Ctrl+Shift+Enter to enter them. If you are not familiar with array formulas, they look like they would not work.

The array formula in E20 in Figure 6.14 shows a formula that does 18 multiplications and then sums the result. It looks like this would be an illegal formula, and if you happen to enter it without using Ctrl+Shift+Enter, you get the expected #VALUE! error. However, if you enter it with Ctrl+Shift+Enter, the formula miraculously multiplies row by row and then sums the result. (You do not type the curly braces when entering the formula.)

Figure 6.14

The array formula in E20 does 18 multiplications and then sums them. You must use Ctrl+Shift+Enter to enter this formula.

Microsoft Fxcet - Tfps and Tricks.xls

|:ig] Bis BPt

^ew insert F&rmat

loot ELara

window

0 0

Post a comment