SOLVED

Sharepoint list with nested IFs

Copper Contributor

Hi

 

I have seen myself blind on this but keep getting syntax error when trying to use this if statement in a calculated cloumn.

 

 

=IF([Type Betaling] = "Månedlig", [Kost pr mnd] * 12, IF([Type Betaling] = "Årlig", [Kost pr mnd], IF([Type Betaling] = "Halvår" ,[Kost pr mnd] * 2, IF([Type Betaling] = "Kvartalsvis", [Kost pr mnd] * 4, [Kost pr mnd]))))

 

 

Hope someone can spot my misstake as I thought this should be possible.

1 Reply
best response confirmed by Danny1300 (Copper Contributor)
Solution
Is your site and web browser in swedish or english? I think swedish uses ; instead of ,
1 best response

Accepted Solutions
best response confirmed by Danny1300 (Copper Contributor)
Solution
Is your site and web browser in swedish or english? I think swedish uses ; instead of ,

View solution in original post