Hi, is there somewhere I can find out in laymans terms, when and how,
different parenthesis, braces colons, etc, should be used and the reasons for
there usage, within excel formulae. Have done all the usual Google searches.

Thanks, keen beginner.

Paul

Paul

Helpbooleanabout calculation operators will give you a pretty good list.

{ } braces usually denote the enclosed operation is an array.

See help on arraysabout array formulas and constants.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 16:22:02 -0700, Paul (Sydney Australia)
wrote:

Hi, is there somewhere I can find out in layman’s terms, when and how,
different parenthesis, braces colons, etc, should be used and the reasons for
there usage, within excel formulae. Have done all the usual Google searches.

Thanks, keen beginner.

Paul

Gord, thanks very, very much. Right there all the time. Easy when you know
how! If you have the time, in plain English, what is an array?

Paul

"Gord Dibben" wrote:

Paul

Helpbooleanabout calculation operators will give you a pretty good list.

{ } braces usually denote the enclosed operation is an array.

See help on arraysabout array formulas and constants.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 16:22:02 -0700, Paul (Sydney Australia)
wrote:

Hi, is there somewhere I can find out in laymans terms, when and how,
different parenthesis, braces colons, etc, should be used and the reasons for
there usage, within excel formulae. Have done all the usual Google searches.

Thanks, keen beginner.

Paul

Plain English.........not sure I can do that<g

Chip Pearson has a good explanation on arrays.

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


Gord

On Tue, 1 May 2007 17:25:01 -0700, Paul (Sydney Australia)
wrote:

Gord, thanks very, very much. Right there all the time. Easy when you know
how! If you have the time, in plain English, what is an array?

Paul

"Gord Dibben" wrote:

Paul

Helpbooleanabout calculation operators will give you a pretty good list.

{ } braces usually denote the enclosed operation is an array.

See help on arraysabout array formulas and constants.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 16:22:02 -0700, Paul (Sydney Australia)
wrote:

Hi, is there somewhere I can find out in layman’s terms, when and how,
different parenthesis, braces colons, etc, should be used and the reasons for
there usage, within excel formulae. Have done all the usual Google searches.

Thanks, keen beginner.

Paul

Thanks again, have a great day.

Paul

"Gord Dibben" wrote:

Plain English.........not sure I can do that<g

Chip Pearson has a good explanation on arrays.

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


Gord

On Tue, 1 May 2007 17:25:01 -0700, Paul (Sydney Australia)
wrote:

Gord, thanks very, very much. Right there all the time. Easy when you know
how! If you have the time, in plain English, what is an array?

Paul

"Gord Dibben" wrote:

Paul

Helpbooleanabout calculation operators will give you a pretty good list.

{ } braces usually denote the enclosed operation is an array.

See help on arraysabout array formulas and constants.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 16:22:02 -0700, Paul (Sydney Australia)
wrote:

Hi, is there somewhere I can find out in laymans terms, when and how,
different parenthesis, braces colons, etc, should be used and the reasons for
there usage, within excel formulae. Have done all the usual Google searches.

Thanks, keen beginner.

Paul