Sharepoint list with nested IFs

/ 2024-07-02 / Microsoft

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.

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. Read More

Tags: microsoft