04-10-2010, 06:19 AM
IF does not take wildcards, but this may help:
=IF(OR(RIGHT(C12,5)="Close",RIGHT(C12,5)="Short"),7,"")
substitute smileys with closing parenthesis
Good Luck!!...
=IF(OR(RIGHT(C12,5)="Close",RIGHT(C12,5)="Short"),7,"")
substitute smileys with closing parenthesis

Good Luck!!...