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: www.excelforum.com/member.php...oamp;userid=32069
View this thread: www.excelforum.com/showthread...hreadid=529572Hi Cereldine,
www.cpearson.com/excel/array.htm
--
Kind regards,
Niek Otten
quot;cereldinequot; gt; wrote in message
...
gt;
gt; Hi, i am making some ammendments to a workbook someone else has created,
gt; with it some of the sheets make extensive use of formulas that resemble
gt; that below, where summ_100 equals a defined range, could someone
gt; explain how and why this works. I'm just a bit unsure as i haven't come
gt; across {} in excel, have an idea that it may be something to do with
gt; arrays.
gt;
gt; {=summ_100}
gt;
gt;
gt; The named range is the same dimensions as the range of cells that use
gt; the formula.
gt;
gt;
gt; --
gt; cereldine
gt; ------------------------------------------------------------------------
gt; cereldine's Profile: www.excelforum.com/member.php...oamp;userid=32069
gt; View this thread: www.excelforum.com/showthread...hreadid=529572
gt;
- Sep 23 Tue 2008 20:46
explain purpose of {}
close
全站熱搜
留言列表
發表留言