check Text

[fitzol]

Dear Gentlemen,

I have typed a text in a cell. Now want to have formula which checks that the required text is in the cell or not.

For example

cell A1 contains rth
In Cell B1 I want the formula =IF(A1=rth).....
But whenever I type the above type of formula an error message occours
Please give suggessions.


Thank you
G.Karthi

[Dave Peterson]

=if(a1="rth", ....



fitzol wrote:
>
> Dear Gentlemen,
>
> I have typed a text in a cell. Now want to have formula which checks
> that the required text is in the cell or not.
>
> For example
>
> cell A1 contains rth
> In Cell B1 I want the formula =IF(A1=rth).....
> But whenever I type the above type of formula an error message occours
> Please give suggessions.
>
> Thank you
> G.Karthi
>
> --
> fitzol
> ------------------------------------------------------------------------
> fitzol's Profile: http://www.excelforum.com/member.php...o&userid=33328
> View this thread: http://www.excelforum.com/showthread...hreadid=531506

--

Dave Peterson

[Leon Noel]

Read this
http://techrepublic.com.com/5100-1035_11-1033368.html
to write a function that checks the cell to if it *contains* the styring
"rth"
Leon



"Dave Peterson" <petersod@verizonXSPAM.net> a écrit dans le message de news:
443A5ACA.E756A988@verizonXSPAM.net...
> =if(a1="rth", ....
>
>
>
> fitzol wrote:
>>
>> Dear Gentlemen,
>>
>> I have typed a text in a cell. Now want to have formula which checks
>> that the required text is in the cell or not.
>>
>> For example
>>
>> cell A1 contains rth
>> In Cell B1 I want the formula =IF(A1=rth).....
>> But whenever I type the above type of formula an error message occours
>> Please give suggessions.
>>
>> Thank you
>> G.Karthi
>>
>> --
>> fitzol
>> ------------------------------------------------------------------------
>> fitzol's Profile:
>> http://www.excelforum.com/member.php...o&userid=33328
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=531506
>
> --
>
> Dave Peterson