ATOI365D#Office365Challenge Sometimes columns give errors due to no data completed or invalid data. This post will show you how to change your formula in your Calculated Column, to not show errors.

Day: 275 of 365, 90 left
Tools: Office 365, SharePoint
Description: SharePoint:  Hide error values in calculated columns
Audience: All

Nothing as annoying as the #DIV/0! error, right?!?!
301116001

On the left you’ll see my original column, on the right, the modified column which will hide the error (or exchange with NA):

  1. =[Income]\[Months]
  2. =IF(ISERROR([Income]/[Months]),”NA”,[Income]/[Months])

301116002

End Result:
301116003

Keep in mind that formulas might differ based on the version you’re working on. Read my post Day 44 – Excel / SharePoint Formulas using Commas or Semicolons for more detail.

Told you, Microsoft’s amazing.

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