Create a simple formula

Important   The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs.

For example, when you enter the formula =5+2*3, Excel multiplies the last two numbers and adds the first number to the result. Following the standard order of mathematical operations, multiplication is performed before addition.

  1. On the worksheet, click the cell in which you want to enter the formula.

  2. Type the = (equal sign) followed by the constants and operators that you want to use in the calculation.

    You can enter as many constants and operators in a formula as you need, up to 8192 characters.

    Tip    Instead of typing the constants into your formula, you can select the cells that contain the values that you want to use and enter the operators in between selecting cells.

  3. Press Enter.



The workbook below shows examples simple formulas. You can change any of the existing formulas, or enter your own formulas to learn how they work and see their results.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.








Adds the values in cells A1 and A2



Subtracts the value in cell A2 from the value in A1



Divides the value in cell A1 by the value in A2



Multiplies the value in cell A1 times the value in A2



Raises the value in cell A1 to the exponential value specified in A2






Adds 5 and 2



Subtracts 2 from 5



Divides 5 by 2



Multiplies 5 times 2



Raises 5 to the 2nd power


To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.

Top of Page

Applies To: Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language