Using wildcards at the beginning of formulae in Excel 97

[Ejnar Sørensen]

I have a formula that I am using similar to: =IF(A1="*licence",TRUE,FALSE

However, this does not equate to TRUE if A1 if the contents ends with the word licence

Is this a bug? and how can I get round this/change it so that I would be able to do the same thing

thanks

Ejnar Sørensen

 

[Paul]

I have a formula that I am using similar to: =IF(A1="*licence",TRUE,FALSE)

However, this does not equate to TRUE if A1 if the contents ends with the word licence.

Is this a bug? and how can I get round this/change it so that I would be able to do the same thing?

thanks,

Ejnar Sørensen

You could use
=IF(RIGHT(A1,7)="licence",TRUE,FALSE)

Or, more simply,
=RIGHT(A1,7)="licence"

 

[Jim]

One way:
=IF(FIND("license",A1),TRUE,"")

 

[Alan]

One possible way,
=IF(RIGHT(A2,7)="Licence",TRUE,FALSE)