Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Adding {} in the formula line

What is the command to bracket a formula with { } . I cant remember

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Adding {} in the formula line

It's used with array formulas. Excel automatically adds them to the formula
when an array formula is entered.

CTRL+SHIFT+ENTER is the key combination used to tell XL that you want an
array formula.
--
Brevity is the soul of wit.


" wrote:

What is the command to bracket a formula with { } . I cant remember

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Adding {} in the formula line

CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP

On Tue, 31 Oct 2006 10:19:02 -0800,
wrote:

What is the command to bracket a formula with { } . I cant remember

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a formula Pam Coleman Excel Discussion (Misc queries) 1 September 26th 06 06:52 PM
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
adding a formula including the value another formula gets Dana Excel Discussion (Misc queries) 7 March 22nd 06 04:00 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"