Can I create an If Statement that will replace text
 

Can I create an If statement that will replace text with text. For example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is not
working. Any helps or tips would be appreciated.

Can I create an If Statement that will replace text
 

=IF(F1="MJW","RGS","JDC")

put this is any other cell and it will display the result.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kalikw" wrote in message
...
Can I create an If statement that will replace text with text. For
example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is not
working. Any helps or tips would be appreciated.

Can I create an If Statement that will replace text
 

try putting quotes around the text

--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
Can I create an If statement that will replace text with text. For
example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is not
working. Any helps or tips would be appreciated.

Can I create an If Statement that will replace text
 

It worked! Thanks so much Bob and Don for your help.

"Don Guillett" wrote:

try putting quotes around the text

--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
Can I create an If statement that will replace text with text. For
example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is not
working. Any helps or tips would be appreciated.

Can I create an If Statement that will replace text
 

glad it helped


--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
It worked! Thanks so much Bob and Don for your help.

"Don Guillett" wrote:

try putting quotes around the text

--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
Can I create an If statement that will replace text with text. For
example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is
not
working. Any helps or tips would be appreciated.