Wrong Output of Nested IF in SharePoint List

Dear Community, I wrote a nested IF statement for a calculated column as below: =IF(AND(J1=0;K1=0);"Level 1";IF(OR(J1=20; K1=60);"Level 3";"Level 2")) Possible values in Column J = 0, 10, 20 an...

microsoft lists

Rob_Elliott
Oct 24, 2023
Vivek_PN a choice column saves a number as text so you need to use Value to convert it to a number for the calculated column. Try this:

=IF(AND(VALUE(J)=0,VALUE(K)=0),"Level 1",IF(OR(VALUE(J)=20,VALUE(K)=60),"Level 3","Level 2"))

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

Rob_Elliott

Silver Contributor

Oct 24, 2023

Vivek_PN a choice column saves a number as text so you need to use Value to convert it to a number for the calculated column. Try this:

=IF(AND(VALUE(J)=0,VALUE(K)=0),"Level 1",IF(OR(VALUE(J)=20,VALUE(K)=60),"Level 3","Level 2"))

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

Vivek_PN

Copper Contributor

Oct 24, 2023

Thanks Rob! It is working now. 🙂

Forum Discussion

Wrong Output of Nested IF in SharePoint List

Resources