You can use the ampersand ( **&** ) symbol in Excel to write multiple formulas in one cell in Excel.

For example, you could type the following into one cell:

="Average sales is "&AVERAGE(B2:B11)&", "&"Sum of sales is "&SUM(B2:B11)

This particular example will calculate the average value in the range **B2:B11** along with the sum of values in the range **B2:B11** and display both outputs in one cell.

The following example shows how to use this formula in practice.

**Example: How to Use Multiple Formulas in One Cell in Excel**

Suppose we have the following dataset in Excel that shows the sales made by various employees at some company:

Suppose we would like to calculate both the average sales value and the sum of the sales and display the output in one cell.

We can type the following formula into cell **D2** to do so:

="Average sales is "&AVERAGE(B2:B11)&", "&"Sum of sales is "&SUM(B2:B11)

The following screenshot shows how to use this formula in practice:

The formula uses the **AVERAGE** function to calculate the average value in **B2:B11**, then uses the **SUM** function to calculate the sum of values in **B2:B11**, then uses the **&** symbol to combine these values with text and display all of the output in one cell.

If you would like to display the average value and sum of values on different lines, you can use the following formula instead:

="Average sales is "&AVERAGE(B2:B11)&CHAR(10)&"Sum of sales is "&SUM(B2:B11)

**Note**: In Excel, **CHAR(10)** is used to represent a line break.

The following screenshot shows how to use this formula in practice:

With cell **D2** still active, click the **Wrap Text** icon on the **Home** tab:

This will cause the text to be displayed on two lines based on where the **CHAR(10)** appears in the formula:

The average sales value and sum of sales value are now shown on different lines.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Replace Blank Cells with Zero in Excel

How to Replace #N/A Values in Excel

How to Ignore #VALUE! Error in Excel

Great article. Very helpful even for a naive like me.

Thank you so much.

Great Article. However, it was challenging to understand your compound formulas since your use of double quotation marks is inconsistent and confusing. They’re meant to enclose string values but they seems to be enclosing formulas or both. Here is how I’d write it: = “Average sales is” &AVERAGE(B2:B11)& “, ” & “Sum of sales is” &SUM(B2:B11)