Formula help - wildcard?

[anniemalec]

Hi

I'm currently using this formula - =IF(($H81="Campaign"),($S81-$Q81),"-")

However due to needing to cover various campaigns I now need the formula to pick up if the cell contains "Campaign" rather than equals campaign.

Are wildcard searches such as this able to be used within an IF formula and if so, what is the syntax?

Thanks
Annie

 

[VoG]

Try

IF(ISNUMBER(FIND("Campaign",H81)),($S81-$Q81),"-")

 

[Aladin Akyurek]

Peter,

SEARCH would be probably more appropriate here...

=IF(ISNUMBER(SEARCH("Campaign",H81)),$S81-$Q81,"-")

 

[VoG]

Thanks Aladin.