Good morning,
In a formaule what is the different bewteen ( ) and [ ]?
Thanks
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

"Sandy" wrote in message
...
Good morning,
In a formaule what is the different bewteen ( ) and [ ]?
Thanks
Sandy

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

"Bernard Liengme" wrote:

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

"Sandy" wrote in message
...
Good morning,
In a formaule what is the different bewteen ( ) and [ ]?
Thanks
Sandy