Apply Mathematical Operations Without Using Formula in Excel 365!!
Tags: applymathematicalope, kutoolsexceltutorial, kutools
Published: 2020-12-01 09:59:07

---
title: Apply Mathematical Operations Without Using Formula in Excel 365!!
published: true
date: 2020-12-01 06:37:49 UTC
tags: ApplyMathematicalOpe,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/apply-mathematical-operations-without-using-formula-in-excel-365/
---

In this tutorial, we will explore how to **Apply Mathematical Operations without Using Formula in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Add a Number to Multiple Cells:

To add a number to multiple cells or a range of cells in Excel, follow the below steps.

- First, you meet to **select a range** that you want to add a number.

![Selected range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Selected-range.png)<figcaption id="caption-attachment-18324">Selected range</figcaption>

- Go to the **Kutools Tab, select** the **More** option, then **select** the **Operation** option from the menu list.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- It will display the **Operation Tools Dialog Box**.
- **Operation –** Here, you need to **select** the **Addition** option.
- **Operand box –** You need to **enter**  **a**  **number** that you need to add to the range.
- You can see the **results** in the **Preview Pane.**
- Then, **hit** the **OK button** to get the result.

![Operation Tools Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Operation-Tools-Dialog-Box.png)<figcaption id="caption-attachment-18325">Operation Tools Dialog Box</figcaption>

- The specified number has been added to all cells in the range s shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Output.png)<figcaption id="caption-attachment-18326">Output</figcaption>

## Subtract a Number from Each Cell in a Column or a Range:

If you want to subtract a number from each cell in a column or a range, follow the below instructions.

- You need to **select a range** where you need to subtract a number.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1.png)<figcaption id="caption-attachment-18328">Input Range</figcaption>

- On the **Kutools Tab, select** the **More** option, then **select** the **Operation** option from the menu list.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- It will display the **Operation Tools Dialog Box**.
- **Operation –** Here, you need to **select** the **Subtraction** option.
- **Operand box –** You need to **enter**  **a**  **number** that you need to subtract from the range.
- You can see the **results** in the **Preview Pane.**
- Then, **click** the **OK button** to get the result.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2.png)<figcaption id="caption-attachment-18329">Click OK button</figcaption>

- Finally, you will get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3.png)<figcaption id="caption-attachment-18330">Result</figcaption>

## Multiply a Range of Cells by a Number:

You can multiply a range of cells by a number or percentage without using any formula. To do this, follow the below steps.

- You need to **select the range** that you want to multiply a number.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4.png)<figcaption id="caption-attachment-18335">Select a range</figcaption>

- Then, on the **Kutools Tab, select** the **More** option, then **choose** the **Operation** option from the menu.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- Then, it will open the **Operation Tools Dialog Box**.
- **Operation –** You need to **select** the **Multiplication** option.
- **Operand box –** You need to **enter**  **a**  **number** or **percentage** that you need to multiply.
- You can see the **results** in the **Preview Pane.**
- Then, **click** the **OK button** to get the result.

![Operation Tools Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5.png)<figcaption id="caption-attachment-18336">Operation Tools Dialog Box</figcaption>

- At last, you will see that the specified number/percentage multiplied with all the cells without using the formula as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6.png)<figcaption id="caption-attachment-18337">Result</figcaption>

## Divide Multiple Cells or a Range of Cells by a Number:

If you want to divide multiple cells or a range of cells by a number without using a formula, do as follows.

- First, you need to **select the range**.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/7.png)<figcaption id="caption-attachment-18338">Select the range</figcaption>

- On the **Kutools Tab, select** the **More** option, then **choose** the **Operation** option from the menu.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- Then, it will open the **Operation Tools Dialog Box**.
- **Operation –** You need to **select** the **Division** option.
- **Operand box –** You need to **enter**  **a**  **number** that you need to multiply.
- You can see the **results** in the **Preview Pane.**
- Then, **click** the **OK button** to get the result.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/8.png)<figcaption id="caption-attachment-18339">Hit the OK button</figcaption>

- Now, the selected cell values have been divided by the given number as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/9.png)<figcaption id="caption-attachment-18340">Output</figcaption>

## Apply Exponential Operation to a Range of Cells:

To apply the exponential operation to a range of cells in Excel, follow the below steps.

- You need to **select the input range** that you want to apply the exponential function. **X<sup>2</sup>**

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/10.png)<figcaption id="caption-attachment-18341">Input Range</figcaption>

- Go to the **Kutools Tab, select** the **More** option, then **select** the **Operation** option from the menu list.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- It will display the **Operation Tools Dialog Box**.
- **Operation –** Here, you need to **select** the **Exponentiation** option.
- **Operand box –** You need to **enter**  **a**  **number** that you need to increase the power of cells.
- You can see the **results** in the **Preview Pane.**
- Then, **hit** the **OK button** to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/11.png)<figcaption id="caption-attachment-18342">Click the OK button</figcaption>

- Now, you can see that the selected cell values have been complete the exponentiation operation as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/12.png)<figcaption id="caption-attachment-18343">Result</figcaption>

## Round a Range of Numbers to Whole Numbers/2 Decimal Places:

If you want to round a range of numbers to whole numbers or two decimal places, then follow the below instructions.

### Round a range of numbers to whole numbers:

- You need to **select the range** that you want to round.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/13.png)<figcaption id="caption-attachment-18345">Select the range</figcaption>

- On the **Kutools Tab, select** the **More** option, then **choose** the **Operation** option from the menu.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- Then, it will open the **Operation Tools Dialog Box**.
- **Operation –** You need to **select** the **Rounding** option.
- **Operand box –** You need to **enter**  **a negative number** ( **For example** , **-2** ).
- You can see the **results** in the **Preview Pane.**
- Then, **hit** the **OK button** to get the result.

![Operation Tools Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/14.png)<figcaption id="caption-attachment-18346">Operation Tools Dialog Box</figcaption>

- Now, the selected cell numbers have been rounded as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/15.png)<figcaption id="caption-attachment-18347">Result</figcaption>

### Note:

- If you want to round the numbers to the nearest **10** , **100** , **1000** , and so on, you need to enter the numbers **-1** , **-2** , **-3** ,… into the Operand box.

### Round a range of numbers to 2 decimal place:

- You need to **select the input range** that you want to round to 2 decimal places.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/16.png)<figcaption id="caption-attachment-18348">Select the range</figcaption>

- Go to the **Kutools Tab, select** the **More** option, then **select** the **Operation** option from the menu list.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- It will open the **Operation Tools Dialog Box**.
- **Operation –** Here, you need to **select** the **Rounding** option.
- **Operand box –** You need to **enter**  **a**  **number** that you want to round.
- You can see the **results** in the **Preview Pane.**
- Then, **hit** the **OK button** to get the result.

![Operation Tools Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/17.png)<figcaption id="caption-attachment-18349">Operation Tools Dialog Box</figcaption>

- At last, you will get the output as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/18.png)<figcaption id="caption-attachment-18350">Result</figcaption>

## Apply a Function to a Range of Cells:

To apply a function to a range of cells in Excel, follow the below steps.

- **Select the cells** that you want to apply the function.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/19.png)<figcaption id="caption-attachment-18351">Input Range</figcaption>

- On the **Kutools Tab, select** the **More** option, then **choose** the **Operation** option from the menu.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- Then, it will open the **Operation Tools Dialog Box**.
- **Operation –** You need to **select** the **Function** option.
- **Addition box –** You need to **choose**  **one function** (we choose the [**Sign** function](https://geekexcel.com/how-to-use-excel-sign-function-in-office-365-with-examples/))from the drop-down list.
- You can see the **results** in the **Preview Pane.**
- Then, **click** the **OK button** to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/20.png)<figcaption id="caption-attachment-18352">Click the OK button</figcaption>

- Finally, you will see that the function has been applied to all the selected cells as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/21.png)<figcaption id="caption-attachment-18353">Output</figcaption>

## Apply Formula to Multiple or All Cells:

You can easily apply any formula to multiple cells in the spreadsheet by doing the below steps.

- You need to **select the range** that you want to apply the customized formula.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/22.png)<figcaption id="caption-attachment-18355">Select the range</figcaption>

- Go to the **Kutools Tab, select** the **More** option, then **select** the **Operation** option from the menu list.

![Select the Operation option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Operation-option.png)<figcaption id="caption-attachment-18321">Select the Operation option</figcaption>

- It will open the **Operation Tools Dialog Box**.
- **Operation –** Here, you need to **select** the **Custom** option.
- **Custom box –** You need to **type** the **formula** that you want to apply.
- You can see the **results** in the **Preview Pane.**
- Then, **hit** the **OK button** to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/23.png)<figcaption id="caption-attachment-18356">Click the OK button</figcaption>

- You can see that the customized formula has been applied to the selected cells as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/24.png)<figcaption id="caption-attachment-18357">Result</figcaption>

### Added Info:

- **Create formulas –** If you check this option, the results will be in the form of formulas for each cell.
- **Skip formula cells –** This option will skip the operation and ignore the formula cells in the range automatically.

## A Short Synopsis:

In this tutorial, we guided you to know the steps to **Apply Mathematical Operations without Using Formula in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Convert Currency (USD to EURO/USD to GBP) in Excel Office 365!!](https://geekexcel.com/wp-admin/post.php?post=18231&action=edit)
- [Filter Data Based on Cell Value With Multiple Criteria in Excel Office 365!!](https://geekexcel.com/wp-admin/post.php?post=18131&action=edit)