SOLVED

AVERAGE & STDEV not formatting correctly across sheets

New Contributor

Hello, 

 

I am having trouble getting AVERAGE and STDEV to format correctly. I am trying to get a summary page going for different samples of different water sources. I am referencing data from a different sheet, and I suspect that is where my issues are.

 

My code looks something like this:

=AVERAGE('Irrigation Water'!E:E)&" (+/- "&STDEV.P('Irrigation Water'!E:E)&")"

It is giving me correct values, but the numbers are returning like such:

7.16666666666667 (+/-2.60874597374975)

 

I would like them to just have two decimal places, but the formatting for the cell isn't changing it. I have the source and return cells all formatted as numbers with 2 decimal places, but it is coming out on it's own.

 

Any advice would be greatly appreciated.

2 Replies
best response confirmed by nagol9109 (New Contributor)
Solution

@nagol9109 

Use the TEXT() function.

TEXT() formats numbers.

 

@Detlef Lewin Of course! Can't believe I didn't think of that sooner. Thank you so much.