For providing interactive spreadsheets that produce outcomes based on input data. All of this is made possible by Microsoft Excel’s formulae and cell-reference system. To perform calculations and obtain a result, you can write formulas on any cell and make references to other cells. To execute several operations and display various outputs based on your procedures and circumstances, you occasionally need to employ many formulas in a single cell. In this article, we will demonstrate how to use multiple **Microsoft** **Excel **formulas in one cell.

**Table of Contents**hide

## Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.

## Step-by-Step Procedures to Use Multiple Excel Formulas in One Cell

In this article, you will learn how to use multiple **Excel **formulas in one cell by utilizing the **Ampersand **operator. Here. We will apply two separate **Excel **formulas in one cell, such as * the SUM function* and

**Let’s suppose we have a sample data set.**

*the AVERAGE function*.### Step 1: Creating Data Set

In this step, **the SUM function **and **the AVERAGE function** are applied in two different cells to show the difference between multiple **Excel **formulas used in one cell and multiple formulas in different cells.

- Here, we want to determine the total sales for all the salespeople and their average sales value.
- Then, we apply the
**SUM**and**AVERAGE functions**to determine the total sales and average sales value in two different cells, respectively.

- Finally, you will observe the final results of the total sales and the average sales.

**Read More: ****How to Apply Same Formula to Multiple Cells in Excel (7 Ways)**

### Step 2: Inserting First Formula

- Firstly, apply the first formula in the following manner.
- So, write down the following formula.

`="Total Sales = "& SUM(C5:C12)`

- After that, hit
**ENTER**.

- As a result, you will see the results for the first formula in the image below.

**Read More: ****How to Apply Formula to Entire Column Without Dragging in Excel**

### Step 3: Utilizing Ampersand Operator

If we want to combine or apply the separate **Excel **formulas in one cell, That is why we use the **Ampersand **operator to put multiple formulas in one cell.

- Here in this step, we use the
**Ampersand**operator at the last position of the first SUM formula to add another formula in the same cell.

**Read More: ****Excel VBA: Insert Formula with Relative Reference (All Possible Ways)**

### Step 4: Inserting Second Formula

In this step, we will demonstrate to you how to combine the second formula with the first formula in one cell by utilizing the **Ampersand **formula.

- So, complete the following two formulas in this section to use
**Excel**formulas in one cell by utilizing the**Ampersand**operator. - Then, write down the following formula in the following manner.

`="Total Sales = "&SUM(C5:C12)&", "&"Average Sales = "&AVERAGE(C5:C12)`

- After that, press
**ENTER**.

**Read More: ****How to Use Point and Click Method in Excel (3 Examples)**

### Step 5: Showing Final Results

- So, this is our final step where you will see the outcome of using two different

## Conclusion

In this article, We’ve covered step by step process of how to use multiple **Excel **formulas in one cell**. **We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on **Excel**, you may visit our website, **Exceldemy**. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.