Thread: [ ]
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default [ ]

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