Explanation of when & how to use ( ) { } : ; , ! etc?

[Paul (Sydney Australia)]

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 Dibben]

Paul

Help>boolean>about calculation operators will give you a pretty good list.

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

See help on arrays>about array formulas and constants.


Gord Dibben MS Excel MVP

 

[Paul (Sydney Australia)]

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]

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

 

[Paul (Sydney Australia)]

Thanks again, have a great day.

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