A little help with 'IF' formula

[duke2k7]

Good morning,

I have read through the forums, and I now have a basic grasp of the 'IF' formula, but I have a question.

I have a column of data that I want to use in respect of:

If any cell in column 'B' contains the word 'BATH', then I need to place the word BATH in column 'C'.

I am using this formula in column 'C' - =- -(COUNTIF(B2,"*BATH*") >0)

Now this gives me 0 for false, 1 for true. Is there any way to substitute the numbers for words?

Hope that makes sense....

Thank you.

[Pete_UK]

Just remove the double minus in front of the formula - those actually convert the TRUE and FALSE values to 1 and 0 respectively.

Hope this helps.

Pete

[Fotis1991]

Hi

Like this?

=IF(--(COUNTIF(B2,"*BATH*")>0),"Exists","NotExists")