[ ]
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 |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com