symbols and characters in excel
I'm new to excel and I'm very interested in formulas. What's the meaning and
how do I use characters and symbols in formulas. For instance when to to use ) instead of )), ", !, etc. Thanks, Miguel |
symbols and characters in excel
Good question!
If you are approaching this from an academic "I want to know everything about ..." corner then you should think about doing some course. Perhaps there are evening classes in your area which will start at "beginners" and then progress through "intermediate" and "advanced". There are several books on the subject starting with dummies guides. Have a look at your book shop or go to www.dummies.com. If you are approaching this from a practical corner there is the Help facility at F1. More useful to you would be to use this NG to describe your query. If you are wanting to use excel to set something up for business then you should, perhaps, speak to your local Excel support guy. In essence, a formula is an 'argument' that says if this is true then do this or, if not, do this. Some formulae are quite extensive. Indeed I have had some which break the 256 character limit. If you reflect back to Algebra those elements within brackets are calculated first. A double brackets occur when there are two (or more) elements which need to be calculated before another calculation. There must always be an equal number of "(" and ")" but Excel will prompt and sometimes even correct these errors. Some errors occur by the use of the arguments "AND" and "OR". The computer is precise in carrying out instructions and you can get some bizarre results leading to some effort in debugging. A trick in writing formulae is always test each and every element against a known answer and NEVER assume that it is 100% correct. Hope that helps - a little at least! Regards. Bill Ridgeway Computer Solutions "vinnmarti" wrote in message ... I'm new to excel and I'm very interested in formulas. What's the meaning and how do I use characters and symbols in formulas. For instance when to to use ) instead of )), ", !, etc. Thanks, Miguel |
symbols and characters in excel
-- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bill Ridgeway" wrote in message ... Good question! If you are approaching this from an academic "I want to know everything about ..." corner then you should think about doing some course. Perhaps there are evening classes in your area which will start at "beginners" and then progress through "intermediate" and "advanced". There are several books on the subject starting with dummies guides. Have a look at your book shop or go to www.dummies.com. If you are approaching this from a practical corner there is the Help facility at F1. More useful to you would be to use this NG to describe your query. If you are wanting to use excel to set something up for business then you should, perhaps, speak to your local Excel support guy. In essence, a formula is an 'argument' that says if this is true then do this or, if not, do this. Some formulae are quite extensive. Indeed I have had some which break the 256 character limit. If you reflect back to Algebra those elements within brackets are calculated first. A double brackets occur when there are two (or more) elements which need to be calculated before another calculation. There must always be an equal number of "(" and ")" but Excel will prompt and sometimes even correct these errors. Some errors occur by the use of the arguments "AND" and "OR". The computer is precise in carrying out instructions and you can get some bizarre results leading to some effort in debugging. A trick in writing formulae is always test each and every element against a known answer and NEVER assume that it is 100% correct. Hope that helps - a little at least! Regards. Bill Ridgeway Computer Solutions "vinnmarti" wrote in message ... I'm new to excel and I'm very interested in formulas. What's the meaning and how do I use characters and symbols in formulas. For instance when to to use ) instead of )), ", !, etc. Thanks, Miguel |
symbols and characters in excel
Sorry didn't mean to send an empty reply.
Your specific question has to do with "nesting" which the same as you learned about when you learned algebra. Would suggest looking up the following in your Excel Help (F1) nesting order of operations parentheses calculation --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com