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!

1 Answer 1


Try using formula like:

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


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


  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]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.