[ ]

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Thank you very much Bernard! The info was very helpful.
Have a nice day!
Sandy

Bernard Liengme said:
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 said:
Good morning,
In a formaule what is the different bewteen ( ) and [ ]?
Thanks
Sandy
Click to expand...
Click to expand...
 
Back
Top