Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
cereldine
 
Posts: n/a
Default explain purpose of {}


Hi, i am making some ammendments to a workbook someone else has created,
with it some of the sheets make extensive use of formulas that resemble
that below, where summ_100 equals a defined range, could someone
explain how and why this works. I'm just a bit unsure as i haven't come
across {} in excel, have an idea that it may be something to do with
arrays.

{=summ_100}


The named range is the same dimensions as the range of cells that use
the formula.


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=529572

  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default explain purpose of {}

Hi Cereldine,

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

--
Kind regards,

Niek Otten

"cereldine" wrote in message
...

Hi, i am making some ammendments to a workbook someone else has created,
with it some of the sheets make extensive use of formulas that resemble
that below, where summ_100 equals a defined range, could someone
explain how and why this works. I'm just a bit unsure as i haven't come
across {} in excel, have an idea that it may be something to do with
arrays.

{=summ_100}


The named range is the same dimensions as the range of cells that use
the formula.


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=529572



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
Explain return of #N/A Biff Excel Worksheet Functions 12 July 13th 05 08:49 PM
Please Explain Formula Karen Excel Worksheet Functions 4 June 16th 05 11:46 PM
Please Explain in Lamen's Terms Karen Excel Worksheet Functions 2 June 16th 05 08:52 PM
access contains several objects explain the purpose of the four c Gord Dibben Excel Discussion (Misc queries) 0 May 11th 05 09:38 PM
Explain these please Sal Excel Worksheet Functions 1 March 24th 05 09:43 PM


All times are GMT +1. The time now is 07:00 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"