One of the user got requirement with colour coding to a list view based on the values selected. so created a calculated columns to achive this functionality. but user experienced error after choose to go with extra color codes (which will extend the Furmula conditions) as:
"Calculated column sysntax error OR not supported", but formula syntax looks fine. After investiagtion
the calculated column supports only 7 levels of IF ELSE conditions in the formula, after that it will through above error. so after googling found solution HERE, and can be achivable by CASE statement as HERE(but i didn't try this)
the output result:
JK
