Calculated Columns in SharePoint Lists Dilimiter Issue
There are many blogs and articles talking about the Calculated Columns in SharePoint or Excel , but few of them highlight the issue with the dilimiters of the formulas.
While formulating the formula, you need to know what is the character used by your SharePoint to dilimiter the paramerters, usually it’s the comma (,), but sometimes it’s the simicoln (;).
So, if you are sure about the formula and it’s not working, then try to change the dilimiter and it will work.
>>> can be changed to >>>>