I have created a calculated column based on the value from another column. 
Typically, it should state the following: 

If the value of the other column starts with 41…. than use an URL, if the value of the other column starts with 42….. than use another url: 

=IF(LEFT([IFS order_SAP Melding], 2)=”41″, “http://example.com/41” & [IFS order_SAP Melding], IF(LEFT([IFS order_SAP Melding], 2)=”42″, “http://example2.com/42” & [IFS order_SAP Melding], “”))

Unfortunately, I receive an syntax error message and cannot cope what the issue is. 

​I have created a calculated column based on the value from another column. Typically, it should state the following: If the value of the other column starts with 41…. than use an URL, if the value of the other column starts with 42….. than use another url: =IF(LEFT([IFS order_SAP Melding], 2)=”41″, “http://example.com/41″ & [IFS order_SAP Melding], IF(LEFT([IFS order_SAP Melding], 2)=”42”, “http://example2.com/42” & [IFS order_SAP Melding], “”))Unfortunately, I receive an syntax error message and cannot cope what the issue is.   Read More

​