Ctrl Shift Enter

[PBROW]

Just curious... I was putting in a formula and when I pressed Ctrl-shift-enter i accidentally pressed only Shift-Enter and the number the formula produced was about 1/5 (6% compared to 36%) of the number that Ctrl-Shift-Enter returned.

I was just curious if anyone knew what the difference is. No big deal, just figured if anyone would know it, it would be this site.

Thanks

[lazyme]

Ctrl+Shift+Enter will turn the formula into an array formula.

Shift+Enter is the same as pressing Enter alone.