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!