Entering Formula Data in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

This article guides you on how to input formula data in Excel.

Working with Excel involves dealing with formulas and functions. Entering formula data is a method of inputting data based on existing data through calculations or using a specific function. To calculate data using formulas, follow these steps:

Step 1: To start with formula input, it's mandatory to begin with an equal sign. In the cell where you want to input formula data, press the equal sign:

Step 2: Next, input the formula to generate data. For example, here revenue is calculated by multiplying quantity * unit price -> enter the formula =[@[Unit Price]]*[@[Quantity]] (as the table is in a column header format).

Step 3: Press Enter -> the result of the formula:

- In case you want to copy the formula for the remaining values, do the following: Select the cell containing the formula to be copied -> move to the bottom right corner of the cell until the mouse pointer turns into a crosshair:

- Hold down the left mouse button and drag to the cells where you want to copy the formula -> see the results:

Here is a detailed guide on how to input formula data in Excel 2013.

Wishing you all success!

Frequently Asked Questions

What are the essential steps to input formula data in Excel?

To input formula data in Excel, start by typing an equal sign in the desired cell. Then, enter your formula, such as =[@[Unit Price]]*[@[Quantity]] for calculations. Finally, press Enter to display the result.

How do I copy a formula to adjacent cells in Excel?

To copy a formula in Excel, first select the cell with the original formula. Then, hover over the bottom right corner until the cursor changes to a crosshair. Click and drag this crosshair across the adjacent cells where you want the formula applied.

Why is it important to start a formula with an equal sign in Excel?

Starting a formula with an equal sign is crucial in Excel because it indicates to the program that a calculation is being entered. Without the equal sign, Excel will treat the input as text rather than a formula, preventing any calculations.

What happens when I press Enter after inputting a formula in Excel?

When you press Enter after inputting a formula in Excel, the program calculates the formula based on the specified data and displays the result in the cell. This allows you to see the outcome of your calculations immediately.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]