If; Then Question

[tobor]

Can anyone tell me why this doesn't work and what will?
=IF(CJ28="*MERA*","Brown","") if I remove the ** it works fine. But the statement is so long I only want to pick up the beginning which starts the same.

Thanks in advance

 

[Scott Huish]

=IF(LEFT(CJ28,4)="MERA","Brown","")

 

[T. Valko]

Can anyone tell me why this doesn't work and what will?
=IF(CJ28="*MERA*","Brown","") if I remove the ** it works fine. But the statement is so long I only want to pick up the beginning which starts the same.

Thanks in advance

The IF function doesn't support wildcards.

Maybe this...

=IF(LEFT(CJ28,4)="MERA","Brown","")