Divide, subtract, add, and multiply in Excel

Calculate percentage of a number

Apply the same math operations to all numbers in the selected range. Division, multiplication, subtraction, and addition are no longer a problem. Find percentage of a number, add percentages to your numbers, or decrease a number by percentage.

Free download for:
2019 2016 365 2013 2010 2007
Ultimate Suite
Learn more
Calculate is part of Ultimate Suite for Microsoft Excel that solves 300+ Excel daily tasks
Calculate Tool for Excel 2019, 2016 - 2007

With Calculate Tool you will

  • Calculate ranges in a click Apply the same math operation to all numbers in a range.
  • Add and subtract Add or subtract a specific number from all selected cells.
  • Calculate percentage in Excel Subtract or add percentage to each cell in a range or find the percentage of all numbers.
  • Multiply and divide Multiply or divide individual cells and entire columns.
  • Apply recent calculations Pick one of the last 10 operations to apply it again.
  • Add new calculations to existing formulas Modify all current formulas in a range automatically based on the math operation you select.

How to quickly calculate multiple cells in Excel

  
How to add number to multiple Excel cells
How to add number to multiple Excel cells
How to subtract percentage from a number in Excel
How to subtract percentage from a number in Excel
Multiply all cells in a column at once
Multiply all cells in a column at once
Add one more operation to the existing formulas
Add one more operation to the existing formulas
Apply one of 10 last calculations again
Apply one of 10 last calculations again
How to add number to multiple Excel cells
How to subtract percentage from a number in Excel
Multiply all cells in a column at once
Add one more operation to the existing formulas
Apply one of 10 last calculations again

License benefits

Our customers get

Unconditional 60-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license for 2 or 5 PCs
or 1 server
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

What is Calculate Tool and what do I need it for?

Calculate Tool lets you apply basic math operations to all cells within a selected range. Add, subtract, divide, or multiply a column by any number. Furthermore, subtract or add a percentage to a number in Excel or calculate a percentage of all the numbers at once.

Isn't Excel designed to calculate numbers without any add-ins?

Yes, it is :) Our Calculate Tool just makes math operations a lot faster and easier to perform, especially for beginners.

How to multiply in Excel with Calculate Tool?

  1. Select the range with numbers.
  2. Select "+" from the tool's drop-down list of options and enter the number.
  3. Click Calculate.

See a more detailed description here.

How to calculate percentage of a number with Calculate Tool?

  1. Select the range with numbers.
  2. Select "%" from the drop-down list of options and enter the percentage.
  3. Click Calculate.

See a more detailed description here.

Does this tool work with existing formulas?

Yes. Calculate Tool can add more calculations to your current formulas.

What if I want to perform the same calculation in another workbook?

Calculate Tool saves the last 10 operations. So, you just open your workbook, select the desired range, and pick one of the last operations you’d like to apply.

Supported versions

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close