ATOI365D#Office365Challenge Here’s an easy formula to calculate the difference between two columns and display the result as a percentage.

Day: 278 of 365, 87 left
Tools: Office 365, SharePoint
Description: SharePoint Using ABS Function
Audience: All

I’ll admit – I used to do this in two steps – first calculate the difference in one column, then divide in another column to determine. Ha ha, lekker stupid hey?

I have two columns in the list on which I want to calculate the percentage increase (or decrease). I then added a third column (calculated), see the screenshot below for the formula. Remember to display the result as number > percentage:

031216001

Here’s the result.

031216002

Voila!

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