HomeApplicationOffice information

How to enter formula data in Excel

The following article shows you how to enter formula data in Excel.

Working with Excel you can not help but work with formulas and functions in Excel. Formula data input is a type of data entry through existing data based on a calculation or a function. To calculate data by formula type follow these steps:

Step 1: To start with the formula input type, it is mandatory to start with equal oil. In the cell to enter data type formula press the equal sign:

How to enter formula data in Excel Picture 1

Step 2: Next enter the type of formula that makes up the data. For example, the revenue here is calculated by the number of * unit prices -> enter the formula = [@ [Unit Price]] * [@ [Quantity]] (because the table is in the table so the formula is in the title of the column)

How to enter formula data in Excel Picture 2

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

How to enter formula data in Excel Picture 3

- If you want to copy the formula for the remaining values, do the following: Click to select the cell containing the formula to copy -> move the lower right corner of the cell when the mouse pointer changes to:

How to enter formula data in Excel Picture 4

- Click and hold the left mouse button to drag the cells to copy the formula -> the results:

How to enter formula data in Excel Picture 5

The above is a detailed guide on how to enter formula data in Excel 2013.

Good luck!

4.5 ★ | 2 Vote

You should read it

May be interested

  • How to Convert Measurements Easily in Microsoft ExcelHow to Convert Measurements Easily in Microsoft Excel
    excel's convert function ('=convert()') converts a measurement from one unit to another. to use this function, you will enter data and units into the formula: =convert(number, 'from_unit', 'to_unit'). first learn how to enter the convert...
  • MS Excel 2007 - Lesson 6: Calculation in ExcelMS Excel 2007 - Lesson 6: Calculation in Excel
    excel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel 2007.
  • How to color formula cells in Excel automaticallyHow to color formula cells in Excel automatically
    coloring formula cells in excel helps us quickly identify cells that use formulas in long data tables.
  • What is ### error in Excel? how to fix ### error in ExcelWhat is ### error in Excel? how to fix ### error in Excel
    ### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
  • How to use formula suggestions in Excel on the webHow to use formula suggestions in Excel on the web
    formula suggestions in the newly released excel online will save you time doing simple calculations. here's how to use the formula suggestion feature in microsoft excel online.
  • How to open the formula management window in ExcelHow to open the formula management window in Excel
    excel supports the formula management window used in the data table so that we can see the formula anywhere on the data table, instead of having to manually scroll up and down.
  • What is the pound sign error (####) in Excel?What is the pound sign error (####) in Excel?
    #### in excel is a frequently encountered excel error and appears in many different cases when we enter data in excel, functions in excel, and enter formulas in excel.
  • Tricks to import data in Excel fastestTricks to import data in Excel fastest
    frequently use excel to enter data, calculate and process data. if you enter data faster, the time spent on calculating and processing data will be more. there are many faster ways to import excel data that you can use.
  • How to fix Excel error 'The formula you typed contains an error'How to fix Excel error 'The formula you typed contains an error'
    when you enter formulas on excel you will sometimes get an excel error 'the formula you typed contains an error'. so how to fix this error on excel?
  • How to Truncate Text in ExcelHow to Truncate Text in Excel
    this wikihow teaches you how to shorten the appearance of data in microsoft excel. to do this, your full, unshortened data will need to be entered into excel first. open microsoft excel. if you have an existing document with your data...

Office information