Formula to find specific Text and if found return blank

[howard]

I have data on Sheet Summary

 =IF(Summary!C46="","",(Summary!C46))

I would like have tried to amend the formula so that if A46 contains "Sales Month End*" , then the result must be blank, otherwise return the result C46

 =IF(Summary!A46="Sales Month End*","",C46)

The formula above returns 0


Kindly amend my formula

 

[Marcelo Branco]

Shouldn't it be
=IF(Summary!A46="Sales Month End*","",Summary!C46)

M.

 

[howard]

Thanks Marcelo

You are 100% correct. Formula works perfectly now

 

[Marcelo Branco]

You are welcome.

M.

 

[howard]

Hi Marcelo


just retested some data and see that wildcard character does not work. I have to insert the full test


Is there another formula for eg search or find that I can incorporate in my formula that will give me the desired result ?

 

[taurean]

Hi Marcelo


just retested some data and see that wildcard character does not work. I have to insert the full test


Is there another formula for eg search or find that I can incorporate in my formula that will give me the desired result ?

Do you mean like below:
=IF(ISNUMBER(SEARCH("Sales Month End",Summary!A46,1)),"",Summary!C46)

 

[howard]

Thanks for the help. Managed to get it to work