Excel Math: How to Add, Subtract, Divide, and Multiply GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

How to Use Basic Math Formulas Like Addition and Subtraction in Excel

By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on December 19, 2021 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook

What to Know

You can subtract, divide, multiply, and add in Excel within the cells of a spreadsheet.You can also do exponents, change order of operations, and do various mathematical functions in Excel.These features rely on cell references to other cells to make calculations. Excel can perform an array of basic math functions, and the articles listed below will show you how to create the necessary formulas to add, subtract, multiply, or divide numbers. Also, learn how to work with exponents and basic mathematical functions.

How to Subtract in Excel

Topics covered: How to subtract numbers using a formula. A step-by-step example of creating a subtraction formula in Excel using point and click. Why using cell references will make it easy to update your calculations if your data should ever change. How to Subtract in Excel

How to Divide in Excel

Topics covered: How to divide two numbers using a formula.A step-by-step example of creating a division formula in Excel using point and click.Why using cell references will make it easy to update your calculations if your data should ever change. How to Divide in Excel

How to Multiply in Excel

Topics covered: How to multiply two numbers using a formula.A step-by-step example of creating a multiplication formula in Excel using point and click.Why using cell references will make it easy to update your calculations if your data should ever change. How to Multiply in Excel

How to Add in Excel

Topics covered: How to add two numbers using a formula.A step-by-step example of creating an addition formula in Excel using point and click.Why using cell references will make it easy to update your calculations if your data should ever change. How to Add in Excel

How to Change the Order of Operations in Excel

Topics covered: The order of operations these spreadsheet programs follow when calculating a formula.How to change the order of operations in formulas. How to Change the Order of Operations

Exponents in Excel

Although less used than the mathematical operators listed above, Excel uses the caret character ( ^ ) as the exponent operator in formulas. Exponents are sometimes referred to as repeated multiplication since the exponent indicates how many times the base number should be multiplied by itself. RapidEye / Getty Images For example, the exponent 4^2 (four squared) has a base number of 4 and an exponent of 2 and is raised to the power of two. Either way, the formula is a short form of saying that the base number should be multiplied together twice (4 x 4) to give a result of 16. Similarly, 5^3 (five cubed) indicates that the number 5 should be multiplied a total of three times (5 x 5 x 5) which calculates to 125.

Excel Math Functions

In addition to the basic math formulas listed above, Excel has several functions — built-in formulas — that can be used to carry out many mathematical operations. These functions include: The SUM function - Adds up columns or rows of numbers. The PRODUCT function - Multiplies two or more numbers together. When multiplying just two numbers, a multiplication formula is more straightforward. The QUOTIENT function - Returns only return the integer portion (whole number only) of a division operation. The MOD function - Returns only the remainder of a division operation. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Subtract Dates in Excel How to Calculate Weighted Averages in Excel With SUMPRODUCT How to Use the Excel DATE Function How to Divide in Google Sheets Google Sheets Formula Tutorial How to Add Numbers in Excel Using a Formula Excel QUOTIENT Function: Divide Numbers How to Combine the ROUND and SUM Functions in Excel Use Excel's EOMONTH Function to Add or Subtract Months Ignore Error Values When Finding the Average in Excel How to Calculate Percentage in Excel How to Multiply in Excel How to Use the Round Function in Excel How to Use a Dynamic Range in Excel With COUNTIF and INDIRECT How to Use Excel's MROUND Function How to Use the Excel TRUNC Function Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies