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