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:
<tbody>
</tbody>
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
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:
Teamwork - Total: 27.3333333333333 Average: 5.466666666667 |
<tbody>
</tbody>
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