software

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.

=IF(F1=quot;MJWquot;,quot;RGSquot;,quot;JDCquot;)

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

--
Don Guillett
SalesAid Software

quot;kalikwquot; gt; wrote in message
...
gt; Can I create an If statement that will replace text with text. For
gt; example
gt; can I write a statement that will do this
gt; If(F1=MJW, RGS, JDC).
gt; I have tried to use the text function and subsitute function but it is not
gt; working. Any helps or tips would be appreciated.
It worked! Thanks so much Bob and Don for your help.

quot;Don Guillettquot; wrote:

gt; try putting quotes around the text
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;kalikwquot; gt; wrote in message
gt; ...
gt; gt; Can I create an If statement that will replace text with text. For
gt; gt; example
gt; gt; can I write a statement that will do this
gt; gt; If(F1=MJW, RGS, JDC).
gt; gt; I have tried to use the text function and subsitute function but it is not
gt; gt; working. Any helps or tips would be appreciated.
gt;
gt;
gt;

glad it helped--
Don Guillett
SalesAid Software

quot;kalikwquot; gt; wrote in message
...
gt; It worked! Thanks so much Bob and Don for your help.
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; try putting quotes around the text
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;kalikwquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Can I create an If statement that will replace text with text. For
gt;gt; gt; example
gt;gt; gt; can I write a statement that will do this
gt;gt; gt; If(F1=MJW, RGS, JDC).
gt;gt; gt; I have tried to use the text function and subsitute function but it is
gt;gt; gt; not
gt;gt; gt; working. Any helps or tips would be appreciated.
gt;gt;
gt;gt;
gt;gt;