Make average sum round up to a full number

[Sam2149]

Hi i am using excel in Office 365 and i have some column's on a data sheet and i am using the average sum to display the average amount from the above cells. this works ok but I would like it to round up the result to a full number if that's possible please

[Pete_UK]

You could use this approach, replacing your existing AVERAGE formula with this:

=ROUNDUP(your_existing_formula,0)

Or you could just format the cells to 0 decimal places (although that would appear to round off rather than round up)

Hope this helps.

Pete

EDIT: please update your profile on User CP to show the current version of Excel that you are using.

[Sam2149]

You could use this approach, replacing your existing AVERAGE formula with this:

=ROUNDUP(your_existing_formula,0)

Or you could just format the cells to 0 decimal places (although that would appear to round off rather than round up)

Hope this helps.

Pete

EDIT: please update your profile on User CP to show the current version of Excel that you are using.

Thanks for the advice I will give your advice a try but I do need it to round up I already have the cell set to no decimal