**Excel** is one of the most useful tools we are familiar with. It enables us to perform myriads of calculations applying the functions available in Excel. But we can also **create a formula in Excel** without using a **function**. In this article, I am going to illustrate **6 cases** where I will create a formula without using a function.

**Table of Contents**hide

## Download Practice Workbook

This is a sample dataset that I am going to use to illustrate how to create a formula in Excel without using a function. Here, we have the **Name** of some employees along with their **Salary Per Day** and **Total Days Worked**.

## 6 Approaches to Create a Formula in Excel without

Using a Function

### 1. Creating Summation Formula in Excel without Using a Function

First of all, I will show you how to **sum** two numbers without using the **SUM function**. I have **Number-1** and **Number-2** and I will calculate the sum in the **Summation column**.

**STEPS:**

➤ Select **D5** and write down the formula

`=54+89`

Here, I am going to add **54** and **89** in **D5**.

➤ Press **ENTER**. Excel will show you the result.

➤ Similarly, you can add the remaining numbers. The output will be like this.

### 2. Subtracting in Excel Without Using a Function

In this section, I will **subtract** two numbers without using any **function**. This time I will use **Cell Reference**.

**STEPS:**

➤ Go to **cell D5**. Write down the formula

`=B5-C5`

Here, I am **subtracting** the number in **C5** (**54**) from the number in **B5** (**89**).

➤ Then press **ENTER**. Excel will show you the result.

➤ Then use the **Fill Handle** to **AutoFill** up to **D9**.

In **D1**, we have a **negative value** (**-1**) because **36 < 37**.

**Read More: How to Create an Excel Formula to Subtract (10 Examples)**

### 3. How to Create a Formula for Multiplication in Excel Without Using a Function

You can also **multiply** in Excel without using a **function**. I am going to show how you can **multiply two columns**. I will calculate **Salary** by multiplying **Salary Per Day** and **Total Days Worked**.

**STEPS:**

➤ Select cell **E5** and write down the following formula.

`=C5*D5`

Here, I am **multiplying** the number in **C5** and **D5 **using the **asterisk (*) **symbol.

➤ Then press **ENTER**. Excel will show you the result.

➤ Then use the **Fill Handle** to **AutoFill** up to **E9**.

### 4. Division in Excel Manually Applying No Function

I will discuss how to perform **division** in Excel manually in this section. Here, I will use the **Salary** and **Total Days Worked** to calculate **Salary per Day** * along the row*.

**STEPS:**

➤ Select **cell C6** and write down the following formula.

**=C5/C6**

➤ Then press **ENTER**. Excel will show you the result.

➤ Then use the **Fill Handle** to **AutoFill** up to **G7**.

** **

### 5. Use of Paste Special to Perform Mathematical Operations

We can also use the **Paste Special** feature to perform mathematical operations. I am going to calculate the **Salary** by **multiplying** **Salary Per Day** and **Total Days Worked**.

**STEPS:**

➤ Select the range **C5:C9**. **Copy** them from the **Context Bar**. The Context Bar will pop up once **you right-click your mouse**.

➤ Now **Paste** them in **E5:E9**.

➤ Now, **Copy** **D5:D9**.

➤Next, select **cell E5:E9**. Then **right click your mouse** to bring **the Context Bar**. Select **Paste Special**.

➤ **Paste Special Window** will appear. Select **Multiply** and then press **OK**.

**You can choose other options too when you need to apply other operations**.

➤ **Excel** will calculate the **Salary**.

➤ The result is in **General Format**. We have to convert it to **Currency Format**.

To do so, go to the **Home** tab >> select the **drop-down box** from **Number Format** >> select **Currency**.

➤ **Excel** will convert them into **Currency Format**.

### 6. Performing Multiple Operations Without Using a Function

You can also perform multiple **mathematical operations** without using a **function**. For instance, I am going to illustrate how to **calculate in percentage** without any **function**.

**STEPS:**

➤ Select **cell E5** and write down the formula.

`=(C5-D5)/D5`

**Formula Breakdown**

**(C5-D5) **⟹ **Subtract** **D5** from **C5** to calculate * the amount* of

**profit/loss**.

Output: **$185**

**(C5-D5)/D5** ⟹ Calculates **the profit/ loss** * with respect to Cost Price*.

Output: **0.226993865**

➤ Then press **ENTER**. **Excel** will calculate the **profit or loss**.

➤ The number is in **General Format**. To transform it into **%**, select the **%** icon from the **Number Format**.

➤ **Excel** will convert the number into **percentages**.

➤ Then use **Fill Handle** to **AutoFill** up to **E9**.

Note that **when the percentage is positive, profit occurs**. But

**.**

__when it is negative ( For instance, in E7), loss occurs__## Practice Workbook

Practice makes a man perfect. That’s why I have attached a practice sheet so that you can practice how to create a **formula** in Excel without using a **function**.

## Conclusion

In this article, I have explained 6 cases to create a **formula** in **Excel** without using a **function**. I hope you will find these cases helpful. Lastly, If you have any queries or suggestions, please leave them in the comment box below.

**Similar Articles**

**How to Create a Formula in Excel to Change Date by 1 Year (3 Methods)****Create a Formula in Excel for Multiple Sheets (4 Methods)****How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)****Create a Custom Formula in Excel (A Step-by-Step Guideline)****How to Create a Formula in Excel for Multiple Cells (9 Methods)**