Forum Discussion
Danny1300
Jul 02, 2024Copper Contributor
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 ,
- Is your site and web browser in swedish or english? I think swedish uses ; instead of ,