ctrl+shift+enter vs enter

[tkaplan]

what is the difference btw confirming with enter and ctrl+shift+enter

 

[Guest]

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

 

[papou]

Hello
If you mean the different ways of validating formulas, then ctrl+shift+enter
will validate an array formula.
HTH
Cordially
Pascal

"tkaplan" <[email protected]> a écrit
dans le message de (e-mail address removed)...

 

[Ron de Bruin]

For the OP

See
http://www.cpearson.com/excel/array.htm

 

[Guest]

Sorry Ron, whats OP ?

 

[Ron de Bruin]

Hi Naz

Original Poster

 

[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.

 

[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.