ATOI365D#Office365Challenge Nope, didn’t know I could do that in SharePoint. Of course being able to calculate ROUNDUP, ODD, or EVEN values in SharePoint is a great way to save time on reworking data.

Day: 281 of 365, 84 left
Tools: Office 365, SharePoint
Description: ROUNDUP, ODD, or EVEN function.
Audience: All

In yesterday’s post we added a column to work out averages. Now as you know – this normally adds some decimals. Today’s post will show you how to ROUND those numbers.

I’ve added a calculated column to ROUNDUP the average column – to “0” decimals (remember to display as number and add as many decimals places as you would like to display):

061216001

Here you’ll see the result:

  • To ROUNDUP to 1 Decimal:      =ROUNDUP([Month Average],1)
  • To ROUNDUP to 2 Decimals:   =ROUNDUP([Month Average],2)

Changing this to =ROUNDDOWN([Month Average],1) will of course Round all numbers down.

061216002

Just using the formula ROUND will round up or down based on the fractional part being greater or less than 5:

=ROUND([Month Average],0)

061216003

 

More:

=EVEN([Month Average],0) – will round up to the nearest even number

=ODD([Month Average],0) – will round up to the nearest odd number

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements