How do I round a formula answer?

Gil Fielding

The above is the average formula I am using which gives me the below answer. I want to round it to a whole number.

Andrée Starå

@Gil Fielding

Happy to help!

It's available in the Sheet Summary section as well, but it's a little hidden.

Here's where.

https://share.getcloudapp.com/9Zujjn7p#

Andrée Starå

Hi Gil,

You can Decrease the Decimal.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Gil Fielding

Hi,

Thanks Andree. I did not see those decimal buttons. My formula is part of a sheet summary which means they aren't available to use.

Cheers

Gil

Andrée Starå

@Gil Fielding

Happy to help!

It's available in the Sheet Summary section as well, but it's a little hidden.

Here's where.

https://share.getcloudapp.com/9Zujjn7p#

Gil Fielding

Fab, Thanks Andree.

Andrée Starå

@Gil Fielding

You're more than welcome!

Have a fantastic weekend!