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?
Thanks!