In this article, we will learn how to combine two formulas in Excel.

Microsoft Excel is a powerful tool for data analysis, calculations, and creating complex formulas. Often, you may need to combine two or more formulas to perform advanced calculations and achieve the desired results. Combining formulas in Excel allows you to build intricate functions and solve more complex problems efficiently.

Here is an overview of combining two formulas in Excel that help users better understand it.

## How to Combine Two Formulas in Excel: 3 Ways

Here we’ll combine two formulas in Excel using the **Ampersand (&) **symbol, the **CONCATENATE, SUMIFS, IF, **and **AND** functions. Let’s follow the instructions below to learn!

### 1. Two Different Formulas in a Single Cell Space in Excel

In this section, we will combine two different formulas using the **Ampersand (&) **symbol and **the CONCATENATE function** in a single cell.

#### 1.1 Using Ampersand Symbol to Combine Two Formulas

Insert the following formula in cell **D18**.

`="Average: "&AVERAGE(E5:E14)&", Total: "&SUM(E5:E14)`

#### 1.2 Use CONCATENATE Function

Now we’ll use **the CONCATENATE function **to combine the **AVERAGE** and **SUM** functions in a single cell.

- Write down the below formula in cell
**D18.**

`=CONCATENATE("Average: ", AVERAGE(E5:E14), ", Total: ", SUM(E5:E14))`

**Formula Breakdown:**

**The AVERAGE function**calculates the average of the cell range**E5:E14.****The SUM function**determines the total sales of the products.**The CONCATENATE function**combines the result of the**AVERAGE**and**SUM**functions.

**Read More:** How to Copy CONCATENATE Formula in Excel

### 2. Apply SUMIFS Function

From our dataset, we will sum up the sales that are greater than *$85,000.00* by applying **the SUMIFS function** and adding the average sales.

- Enter the following formula in cell
**D18**.

`=D16+SUMIFS(E5:E14,E5:E14,">85000")`

**Formula Breakdown:**

**The SUMIFS function**will sum up the sales that are greater than*$85,000.00.*- Hence, the mathematical operator plus(+) symbol combines the result of
**the SUMIFS function**with the value of the cell**D16.**

**Read More:** How to Concatenate Date/Day, Month, and Year in Excel

### 3. Nested IF and AND Functions

We will nest **the AND function** inside **the IF function** to check the sales status of the sales representatives.

- In cell
**F5**, type the following formula.

`=IF(AND(E5>D5),"Accomplished","Not Accomplished")`

**Formula Breakdown:**

**If**the value of cell**E5**is**greater than**the value of cell**D5**,**the AND function**will return**TRUE**otherwise**FALSE**.- If the sales by
**Rozalie Freke**is**greater than D5**then**the IF function**will return**Accomplished**otherwise it returns**Not Accomplished**.

**Read More:** How to Concatenate Names in Excel

## How to Use Nested SUBSTITUTE Function in Excel

In this section, we will nest **the SUBSTITUTE function** to change a particular text from a specific position in Excel.

- Write down the following formula in cell
**D5**and**AutoFill**the formula.

`=SUBSTITUTE(SUBSTITUTE(B5,"a","e"),"oo","o")`

**Formula Breakdown:**

- Inner
**SUBSTITUTE**function, replaces “**a**” with “**e**”. - Outer
**SUBSTITUTE**function, replaces “**oo**” with “**o**”.

**Read More:** How to Concatenate Date and Time in Excel

## Things to Remember

- Use the
**“&”**operator to combine text or results of formulas. - Always double-check your formulas for accuracy and ensure correct cell references.
- Parentheses control the order of operations in nested formulas.

## Frequently Asked Questions

** 1. How can I combine the results of two different formulas into one cell in Excel?**

**Answer:** You can use the “**&**” operator to concatenate the results of two formulas. For example, if you have two formulas in cells **A1 **and **B1**, you can combine them with the formula “**=A1&B1**” in another cell to display their outputs together.

** 2. Is it possible to multiply the results of two formulas and display the combined result in another cell?**

**Answer:** Absolutely! You can multiply the results of two formulas by referencing their cells in a new formula. For example, if you have formulas in cells **A1 **and **B1**, you can use the formula “**=A1*B1**” in another cell to display the combined multiplication result.

** 3. Can I use logical functions like AND or OR to combine the results of two formulas based on certain conditions?**

**Answer:** Yes, you can use the logical functions **AND **and **OR **to combine the results of two formulas based on specific conditions. For example, to check if both **A1 **and **B1 **are greater than 10, you can use the formula “**=AND(A1>10, B1>10)**“.

**Download Practice Workbook**

Download this practice workbook for practice while you are reading this article.

## Conclusion

We have learned how to combine two formulas in Excel that offer powerful ways to enhance calculations and analysis. Utilizing nested formulas and the “**&**” operator for concatenation opens new avenues for data analysis and presentation.

With careful attention to accuracy and best practices, users can create sophisticated spreadsheets that streamline workflows and improve decision-making processes.

## Related Articles:

- Excel VBA: Combine Date and Time
- Carriage Return in Excel Formula to Concatenate
- How to Combine Names in Excel with Space
- How to Combine Name and Date in Excel