May 04 2021 11:56 AM
I've been trying to figure out an IF formula for a Sharepoint Calculated Column.
Column A = IA, IB, IC, ID, IIA, IIB, IIC, IID, IIIA, IIIB, IIIC, IIID, IVA, IVB, IVC, IVD
I want a calculated column where:
IF Column A = IA, IB, IIA, then calculated column = 1
IF Column A = IC, IIB, IIIA, then calculated column = 2
IF Column A = ID, IIC, IIIB, IVA, then calculated column = 3
IF Column A = IID, IIIC, IVB, then calculated column = 4
IF Column A = IIID, IVC, then calculated column = 5
IF Column A = IVD, then calculated column = 6
Any ideas
May 04 2021 10:29 PM
Solution@petertheo89 Try using below formula:
=IF(OR([Column A]="IA", [Column A]="IB", [Column A]="IIA"), 1, IF(OR([Column A]="IC", [Column A]="IIB", [Column A]="IIIA"), 2, IF(OR([Column A]="ID", [Column A]="IIC", [Column A]="IIIB", [Column A]="IVA"), 3, IF(OR([Column A]="IID", [Column A]="IIIC", [Column A]="IVB"), 4, IF(OR([Column A]="IIID", [Column A]="IVC"), 5, IF([Column A]="IVD", 6, 0))))))
Return the calculated field as Number.
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Official Documentations:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
May 04 2021 10:29 PM
Solution@petertheo89 Try using below formula:
=IF(OR([Column A]="IA", [Column A]="IB", [Column A]="IIA"), 1, IF(OR([Column A]="IC", [Column A]="IIB", [Column A]="IIIA"), 2, IF(OR([Column A]="ID", [Column A]="IIC", [Column A]="IIIB", [Column A]="IVA"), 3, IF(OR([Column A]="IID", [Column A]="IIIC", [Column A]="IVB"), 4, IF(OR([Column A]="IIID", [Column A]="IVC"), 5, IF([Column A]="IVD", 6, 0))))))
Return the calculated field as Number.
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Official Documentations:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.