[ ]

[Sandy]

Good morning,
In a formaule what is the different bewteen ( ) and [ ]?
Thanks
Sandy

 

[Bernard Liengme]

Hi Sandy:

Square brackets [ ] are used around file names, as in =[Book2]Sheet1!$A$1
Parentheses are used to delimited function parameters, as in =SUM(A1:A100)
and to override the normal order of precedence of operators, as in
=(A1+A2)/2 which sums A1 and A2 then divides by 2 while =A1+A2/2 first
halves A2 and adds the result to A1

Might be time to get a simple Excel book - have a look at www.abebooks.com
for a used one

Suggestion: Try to make the subject in your messages a bit more informative.
best wishes

 

[Sandy]

Thank you very much Bernard! The info was very helpful.
Have a nice day!
Sandy

Hi Sandy:

Square brackets [ ] are used around file names, as in =[Book2]Sheet1!$A$1
Parentheses are used to delimited function parameters, as in =SUM(A1:A100)
and to override the normal order of precedence of operators, as in
=(A1+A2)/2 which sums A1 and A2 then divides by 2 while =A1+A2/2 first
halves A2 and adds the result to A1

Might be time to get a simple Excel book - have a look at www.abebooks.com
for a used one

Suggestion: Try to make the subject in your messages a bit more informative.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Good morning,
In a formaule what is the different bewteen ( ) and [ ]?
Thanks
Sandy