samedi 31 janvier 2015

Validating Password based on nested IFstatements and FIND function Problem



I am having trouble figuring out how to validate multiple special characters in SharePoint 2010 when a user inputs a password. The special characters that are allowed are: !@$*+ . When i have one IF statement such as: =IF(FIND("!",Password),TRUE) , it works just fine and will inform the user there is no "!" if it isnt entered.


My problem is finding out how to enter in multiple IF statements to valid if any of the following special characters:!@$*+ are entered.


If i do a IF statement saying: =IF(OR(FIND("!",Password),TRUE),IF(FIND("@",Password),TRUE) it will only validate and allow passwords when both the !@ specials characters are entered, when it needs only one of the special characters to be correct, not both. Any help would appreciated, thanks!








0 commentaires:

Enregistrer un commentaire