Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
excel i viticaste zagrade
181 views
Skip to first unread message
moki
Mar 2, 2009, 4:14:42 PM3/2/09
to
da li netko zna sto znace u formuli u excelu one viticaste zagrade {}???
Cinho
Mar 2, 2009, 5:31:17 PM3/2/09
to
"moki" <mo...@nema.mail> je napisao u poruci interesnoj
grupi:gohi85$sgu$1...@ss408.t-com.hr...
> da li netko zna sto znace u formuli u excelu one viticaste zagrade {}???
"Those brackets show up when you enter a formula by hitting
CONTROL+SHIFT+ENTER at the same time, instead of just enter as in
=MIN(IF(A1:A10,A1:A10))
which, when entered by hitting CONTROL+SHIFT+ENTER at the same time, will
appear on the Formula Bar as
{=MIN(IF(A1:A10,A1:A10))}
The only time you enter these curly brackets yourself is when you feed some
function a constant array as argument as in
=VLOOKUP(A1,{"a",1;"b",2;"c",3},2,0)
where {"a",1;"b",2;"c",3} represent a 2-column table.
Curly brackets are thus associated with the so-called array formulas and
constant arrays."
ili
http://www.bettersolutions.com/excel/EDK153/LT423111411.htm
0 new messages