Can I create an If Statement that will replace text

K

kalikw

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.
 
B

Bob Phillips

=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)
 
Top