Perform math operations on a range of cells

Using the Calculate tool, you can apply basic mathematical operations, such as addition, multiplication, subtraction, or division, to the entire range in a click. What's more, you can add and subtract percentage or find the percentage of a number - all for multiple cells at once.

How to do quick calculations in Excel

  1. Select a range that contains the numbers to calculate in your Excel table:
    Pick a range in your table where you need to apply the mathematical operation.
  2. Find the Calculate group on the Ablebits Tools tab, pick the Operation you need from the drop-down list, and enter a number in the Value field:
    Select the necessary mathematical operation from the drop-down list.
  3. Click the Calculate button to see the result:
    Click Apply and get the result right away.
Note. If the cell/range in your table contains a formula, it will be modified according to the operation you select. For example, you have a formula "=A1+B1" in the selected cell and you choose to calculate the percentage "- %50". When you click Calculate, the formula will change to "=(A1+B1)*0.5". In other words, this changes whole formulas, not only values.
Tip. The last 10 operations are saved in the Apply Recent list. To see the latest operations, click the Apply Recent button on the toolbar and pick the operation you'd like to apply to the selected cell or range.
See the last 10 operations in the Apply Recent list.

Responses

Good Day

Hope this message finds you well...

I have this arithmetic Patten that just adds a certain number,I used the =SUM function to get my value which was correct, but to continue with the Patten I need to drag it down to my desired value without reputation of the initial answer.

The patten goes like:

1234
1345
1456 and so on...

to get that I used the difference of each number, which is 111. But now I need excel to automatically add this 111 to the answer I get when dragging down the column to get the Patten straight without reputation .
I hope my explanation is clear, your assistance will be highly appreciated.

Regards

Tshepang

Reply

Hi Tshepang,
If I have understood your task correctly, the solution is simple. You don’t even have to use the SUM function.
So,
1. Enter 1234 into A1.
2. 1345 into A2.
3. 1456 into A3.
4. Select the A1:A3 range and you will see the fill handle that is a little square in the lower-right corner of the selection.
5. Click on the fill handle and drag it down. The cells will be automatically filled with the numbers you need:
1234
1345
1456
1567
1678
1789
1900

Hope this will help you!

Reply

I need to calculate the difference between a start time and end time in minutes. Always on the same day so the date is not necessary. How would I do this?

Reply

Hello Lisa,
Thank you for contacting us.

It looks like our Date & Time Formula Wizard may come in handy. It allows you to find a difference between two times in a few clicks. This add-in is available as a part of our Ultimate Suite for Excel that you can install in a trial mode and use it for 30 days for free. Here is the direct download link for you: https://www.ablebits.com/files/get.php?addin=xl-suite&f=free-trial

You can also check the detailed instructions on how to work with Date & Time Formula Wizard on its help page: https://www.ablebits.com/docs/excel-calculate-dates-time-age/

Reply
Kevin Mathews says:
November 8, 2019 at 10:20 pm

Is it possible to revise a range of formulas? For example, apply Round([existing formula],1).

Reply
Katerina Bespalaya says:
November 11, 2019 at 11:28 am

Hello Kevin,

Unfortunately, we don't have a tool in our Ultimate Suite for Excel that could perform this operation.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard