# Results of formulas in same cell

I have a weekly tracking sheet which I'm trying to get the result of 2 averages next to each other in the same cell.

Column B has a number value in each cell for each day of a week
Column G has a number value in each cell for each day of a week
In a cell in column A I want to display the averages of each of the cells from these columns for the last 7 days next to each other with a label.

The formula I have so far in the cell I want to display is:

``````=AVERAGE(C34:C40) &AVERAGE(G34:G40)
``````

I've got it to display the values but all in a continuous string and the first average result has lots of decimal places after even though when it is in a cell by itself it shows as 1 which is correct, I can't seem to change this?

I also want to add a label to each of the results with the final result in the single cell being:

``````Weight:result1 Calories:result2
``````

Hope that makes sense if someone can suggest what I need to tweak to get the right display that would be great.

• It would be helpful if you could share an example sheet in your question, but in general, would the CONCATENATE() formula not work? I think this will give you what you want, you can join text and other formulas together into one string. May 8, 2021 at 4:00

You can use `round()` to choose how many decimals to show, and the `&` operator to concatenate text strings and numbers into one text string, like this:
`="Weight: " & round(average(C34:C40), 2) & " Calories: " & round(average(G34:G40), 2)`
• Perhaps you can just use `average(C34:C40)` where you need the average weight. May 9, 2021 at 20:51