Calculated "Average" Column Shows Too Many Decimals

Question

I've got column where I'm using a formula to calculate the average of a few other columns. It keeps showing a bunch of decimals even with the decimals set to 2 on the column.

I've seen where some folks suggest to use the TEXT function to format the final value and others are suggesting using the ROUNDUP function. I just can't get the syntax right though and SharePoint won't accept my attempts.

If you want to use a formula inside another function what is the right syntax?

Example if I have the following:

=AVERAGE([Number One]), Two, [Number Three])

How do I limit the output to 2 decimal places? I've purposely included columns with spaces and columns without because that is what I'm faced with.

Thanks for any guidance!

Answer 1

Try using formula like:

=ROUND(AVERAGE([Number One]), Two, [Number Three]), 2)

Documentations:

1. ROUND function
2. ROUNDUP function
3. ROUNDDOWN function

Note:

1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
2. Use correct display name of your SharePoint columns in above formula.
3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name]