Limiting length of values returned by a formula within the formula itself

[Rusty315]

Hi

I'm using this formula:

=IFERROR("Leadership - Total: "&(SUM(G42:G46))&" Average: "&(AVERAGE(G42:G46)),"Leadership")

It works just fine but the result of the sum and average portions of the formula are very long and I get results that look like this:

[TABLE="width: 688"]
<tbody>[TR]
[TD="class: xl63, width: 688"]Teamwork - Total: 27.3333333333333 Average: 5.466666666667
[/TD]
[/TR]
</tbody>[/TABLE]

Formatting the cell won't change the length of these numbers. Is there a way to limit these numbers to 2 or 3 decimal places by changing the formula somehow?

Appreciate any help anyone can give!

Cheers

 

[Michael M]

Try

=IFERROR("Leadership - Total: "&(ROUND(SUM(G42:G46),2)&" Average: "&ROUND(AVERAGE(G42:G46),2)
,"Leadership")

 

[Rusty315]

Excellent, worked perfectly with a minor adjustment:


=IFERROR("Leadership - Total: "&(ROUND(SUM(G42:G46),2))&" Average: "&ROUND(AVERAGE(G42:G46),2)) ,"Leadership")

Just needed that extra bracket after the 2.

Thanks for your help! It's much appreciated.
</pre>

 

[Michael M]

Pleasure.....thanks for feedback...