array formulas

[R.VENKATARAMAN]

some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from looking at
the formulas

 

[Niek Otten]

In the formula bar, array formulas appear in curly brackets {}

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[mangesh_yadav]

array formula is inside curly braces {}

Manges

 

[R.VENKATARAMAN]

sorry I did not frame the question correctly.
what I meant is suppose I get some foirmula from one of the newsgroups and
forgot to download the whole message I would like to know how to distinguish
the formula. does it mean when I copy the formula in a cell automatically
the curly brackets will appear in the formula bar?

 

[Bob Phillips]

No it doesn't, you need to add them by committing with Ctrl-Shift-Enter, not
just Enter.

It can be worse if they include {..} in their response as you then have to
remove them. But this is similar to long formulae that extend over multiple
lines, I have to re-join these back in Excel.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

It can be worse if they include {..} in their response as you then have to
remove them. But this is similar to long formulae that extend over multiple
lines, I have to re-join these back in Excel.

But only remove those brackets that are at the beginning and end of the
formula; don't remove any brackets that are inside the formula as they
represent array constants.

e.g.

{=SUM(--(A1:A10={1,2,3,4}))}

Remove the outside brackets and not those representing the array constant:

=SUM(--(A1:A10={1,2,3,4}))


--ron

 

[Bob Phillips]

Good point

Bob

But only remove those brackets that are at the beginning and end of the
formula; don't remove any brackets that are inside the formula as they
represent array constants.

e.g.

{=SUM(--(A1:A10={1,2,3,4}))}

Remove the outside brackets and not those representing the array constant:

=SUM(--(A1:A10={1,2,3,4}))


--ron

 

[Guest]

In the formula status bar you should see the formula in brackets {=formula}