# How to Combine Two Formulas in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

### 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.

### 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.

## 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”.

## 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.

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)“.

## 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. Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  