Forum Discussion
Solved
Sharepoint list, Calculated Column, IF syntax error
Hi all, I have the following problem: I have a SharePoint list with different columns. Column 1 = single choice column with drop-down and values 1, 2, 3 Now I want to create a Column 2 = calcu...
Dimitrij_P it needs to be =if([Column 1]="3","OK","NOK")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hello there, could you please give me a help hand here?
I dont know where is the issue, its little more complikcated formula..
Its all about one collumn, basically there are few conditions
If the number in collumn 1 is > 6950000 then in new calculated collumn should be 40% and etc.
=IF([collumn1]<6950000,"0%",
IF(AND([collumn1]>=6950000,[collumn1]<7050000),"40%",
IF(AND([collumn1]>=7050000,[collumn1]<7150000),"50%",
IF(AND([collumn1]>=7150000, [collumn1]<7200000),"60%",
IF(AND([collumn1]>=7200000, [collumn1]<7250000),"70%",
IF(AND([collumn1]>=7250000, [collumn1]<7350000),"80%",
IF(AND([collumn1]>=7350000, [collumn1]<7500000),"90%",
IF([collumn1]>=7500000,"100%",
)
)
)
)
)
)
)
)
Hi, try this
=IF([column1]<6950000, "0%", IF(AND([column1]>=6950000,[column1]<7050000), "40%", IF(AND([column1]>=7050000,[column1]<7150000), "50%", IF(AND([column1]>=7150000,[column1]<7200000), "60%", IF(AND([column1]>=7200000,[column1]<7250000), "70%", IF(AND([column1]>=7250000,[column1]<7350000), "80%", IF(AND([column1]>=7350000,[column1]<7500000), "90%", IF([column1]>=7500000, "100%")))))))))