3

Hi can I use the <> operator in a SharePoint Calculated column? The following formula is accepted but I'm not sure it is supported. My requirement is:

If any values equal High AND are not equal to Low then C, else B

=IF(OR([field1]="High",[field2]="High",[field3]="High",[field4]="High",[field5]="High",[field6]="High"),"High",IF(OR([field1]<>"Low",[field2]<>"Low",[field3]<>"Low",[field4]<>"Low",[field5]<>"Low",[field6]<>"Low"),"C","B"))

If the statement is not supported, how can I write a <> statement?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.