- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
All formulas begin with an equals sign (=).
Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division. For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
Other formulas refer to different functions such as SUM, AVERAGE and others. For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
Formulas can be combined with operands. For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
Functions can be nested within each other. For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
Here are a few links that will help you:
<div>If you need further assistance please leave a comment.</div>
Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.
Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1
Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1
Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1
I hope this resolves the question. If not, please let me know.
Put the figure which you have to multiply in cell A1, Put the figure in cell A2 by which you have to multiply by, type =A1*A2 in cell A3. You will get the right answer.
You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.
Very simple fix. Now and then after an Adobe Acrobat update Office will disable Adobe Acrobat as it is an add on. All you need to do is re-enable Adobe Acrobat. In Office 2007 goto Word Options, Add-ons, and at the bottom of the page is Manage. Click on the down arrow and select Disabled Items and click on GO. Re-enable Acrobat and you should be fine. In Office 2003, goto Help and selects disabled macros and re-enabler Acrobat.