- 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.
Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
In the menu bar, go to Format - Cells
In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
Deselect the small box tagged Locked
Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
Select only the cells containing formulas that you want to hide (If
you need to perform multiple selection, you can press and hold down the
Ctrl key, while clicking on each cell you want to select)
In the menu bar, go to Format - Cells
In the popup menu that opens, click on the Protection tab
Tick the small box tagged Hidden and the Locked box as well. If you
don’t tick the Locked box, other users of your worksheet would be able
to overwrite the formula cells, without even knowing that they contain
formulas (as they become invisible following this operation).
Click on OK
In the menu bar, go to Tools - Protection - Protect Sheet
If you want, you can input a password for unlocking the worksheet.
This will prevent others from unlocking it. If you don’t want to do
that, leave the password field blank and press OK.
Now click on one of your cells containing formulas and look at the
formula bar. It should be empty, although the formula is still there.
The cell would remain locked, but it would be automatically updated
when changing the content of its precedents relating to the contained
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.
That depends on which version of Excel you are using. Excel 2003 supports up to 65,335 formulas Excel 2007 has no limit. you can communicate between the worksheets which are contained by one workbook (one excel-file). Communicating between files cannot be done with formula's.
The most likely problem is that you (or somebody) has R1C1 reference style turned on.
In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.
Just uncheck the box and click OK.
I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.