Forum Discussion

Danny1300's avatar
Danny1300
Copper Contributor
Jul 02, 2024

Sharepoint list with nested IFs

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.

  • Is your site and web browser in swedish or english? I think swedish uses ; instead of ,

Resources