Do I need to start with an equal sign when entering a formula in excel?

Do I need to start with an equal sign when entering a formula in excel?

When entering a formula in excel, it needs to start with an equal sign.

How to enter formulas in excel

First click with the mouse to select the cell where you want to enter the formula.

Recommended: "Excel Tutorial"

After selecting the cell, you can enter the formula directly in the cell Input, you can also click the edit bar above excel and enter the formula in the edit bar. After input, the formula content will be displayed in the cell and edit bar. Personally, I find it more convenient to enter formulas in the edit bar.

First you need to enter an equal sign, which is equivalent to telling the Excel program that this is the beginning of a formula.

Then enter other contents of the formula. For example, in this example, enter "=1 2". After input, the formula contents will be displayed in the cell and edit bar.

After entering the formula, click the check button on the left side of the edit bar, or press the Enter key to end the input. Excel will automatically Calculation.

After pressing the check button or the Enter key, the calculation result of the formula will be displayed in the cell. The formula content will be displayed in the edit bar.

#Excel formulas can reference cells, so that the contents of the referenced cells are calculated. You can directly enter the cell name for reference. Such as "=B2 C2". But the most convenient thing is to enter the equal sign, move the mouse, and click on the cell to be referenced, such as clicking on cell B2. In this way, B2 is automatically added after the equal sign. After entering the operator, click on other cells. This makes it easy and fast to calculate other cells.

After pressing the check mark button or the Enter key, if there is an error in the entered formula, excel will pop up a dialog box prompting formula errors and modification suggestions. If you accept the modification suggestions, just click "OK", otherwise you need to close the dialog box and modify the formula manually.

Here is just a brief introduction on how to enter formulas in excel. Excel formulas can contain many contents, such as: text, functions, function parameters, parentheses, etc. These need to be gradually mastered during use.

The above is the detailed content of Do I need to start with an equal sign when entering a formula in excel?. For more information, please follow other related articles on the PHP Chinese website!