View Single Post
  #7   Report Post  
MrShorty
 
Posts: n/a
Default


enter confirms a normal formula.

ctrl+shift+enter confirms an array formula (search Excel help for array
formula and you'll find some information). Array formulae come in two
types:
1) Performs a calculation on each element of an array in the process of
acheiving the results. SUMPRODUCT is often used in this way
(=sumproduct(--(a1:a102),b1:b10). Because it performs the comparison
step on each element in the range, it needs to be entered as an array
formula.

2) An array formula can also return multiple values in the process of
acheiving its result. Matrix functions (MMULT, TRANSPOSE, etc) fall
into this category. Functions like LINEST and LOGEST which return two
parameters for the given curve fit.

That's a little information on array formulas. They can be useful
tools in a spreadsheet, depending on what you need to make a
spreadsheet do.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=374550