ctrl+shift+enter vs enter

N

Naz

The difference is that for a normal formula you use Enter,
However there is a special kind of formula called an Array formula which can
only be entered using Ctrl+Shit+Enter. When doing so it will enter special
curly brackets to indicate it is an Array formula
 
M

MrShorty

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:a10>2),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.
 
T

tkaplan

thank you.
wow i feel so stupid that i didnt know that....
i usually do all my array stuff with VB so i never tried that.
but good to know.
thanks.
 
Top