Translate a number to a text

[#1]

I have a field that has a number stored in it.  I want to display a text.  example

when table.field = 60  display Not Started....

[sunny_talwar]

May be like thi:

=If(table.field = 60, 'Not Started')

[swuehl]

You can use a MAPPING table approach to map your numbers to text:

Mapping … and not the geographical kind

Data Cleansing

Note when reading these blog posts that it doesn't matter what values you are mapping (numbers or Names or Countrys), the mapping table is just a lookup table with Key / Value pairs.