I want a Calculated Column in SharePoint 2013 that is based on Yes/No from another Column. So I have a Column with Yes/No called "Error". I have another column that say "Error Id" and it is a calculated column too.

I am using the formula for "Error ID " Column as

=IF(Error="yes", (Concatenate("ERR",[ID]))). 

This worked for when the "Error" column is selected as "Yes" But I want add that if Error Column is "No" then say "N/A" in the same formula.

How do I do that?


1 Answer 1


Looks like you simply need to put "n/a" into the FALSE parameter of the IF statement. I assume that you are aware of the IF() syntax, i.e.

IF(<condition>, <do when true>, <do when false>)

So, for your formula that would be

=IF(Error="yes", Concatenate("ERR",[ID]),"n/a")

I've also removed the superfluous pair or round brackets you had around the concatenate function.

  • If that resolved your issue, please mark the answer as described in the tour. If it didn't, please leave a comment, so I can follow up.
    – teylyn
    Oct 12, 2021 at 20:25
  • It worked. Thank you!
    – Nina
    Oct 12, 2021 at 21:24
  • 1
    Great. Now please accept the answer as described in the tour. That is how you say Thank you when someone has helped you here.
    – teylyn
    Oct 13, 2021 at 2:15
  • Welcome @Nina to SE community, As you're a new contributor, I would suggest having a quick tour as explained at tour! Also, please don't forget to mark the answer as accepted if it was helpful for you Oct 13, 2021 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.