If this then that

  • Thread starter Thread starter B-positive
  • Start date Start date
B

B-positive

Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"
 
I suggest you to use an auxiar cell with:

=if(a1="1","Final Draft",if(a1="2","rough draf",false))

replace is possible using "auto correct", but if you need to type 1 or 2 it
will be replaced..

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"B-positive" escreveu:
 
Use a number format (Format/Cells, click Custom category):
[=1]"final draft";[=2]"rough draft";General
 
To Bob Umlas,

This works but it seems to work only for two variables ie (1 or 2) but I
can't seem to get it to work for more than 2. Is there another trick to that?
 
Hi B,

You could use Auto Correct replace text as you type.
Just use an odd key combination that you are not
likely to use anywhere else e.g.
|1 |2 |3
or maybe
...1 ..2 ..3
or
zz1 zz2 zz3
or......whatever!

HTH
Martin
 
Can this only be used with two numbers? What if 1 & 2 = final and 3 & 4 =
rough?
thanks - just learning

dp

Bob Umlas said:
Use a number format (Format/Cells, click Custom category):
[=1]"final draft";[=2]"rough draft";General


B-positive said:
Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"
Click to expand...
Click to expand...
 
Back
Top