LOWER and UPPER scenario

LOWER and UPPER scenario:

Check a box even if the text field values are in lower or upper case (to find if text field value contains upper or lower case):

e.g. - If 2nd value is CONTAINS( Name , "XyZ" )- require the formula to check even value is lower case like 'kuban'.

OR(

CONTAINS( Name , "Abc"  ),

CONTAINS( Name , "XyZ"  ),

CONTAINS( Name , "Pqr"  )

)

Solution:

Please change each of the above line with CONTAINS statement as below -

CONTAINS(LOWER(Name) , "XyZ")

So,

OR(

CONTAINS( LOWER(Name) , "Abc"  ),

CONTAINS( LOWER(Name) , "XyZ"  ),

CONTAINS( LOWER(Name) , "Pqr"  )

) 

Same way we can implement for UPPER.