Thanks for your reply.

In some cases I would like to get a word or name insted of a letter as result.

Something like the following:

=
IF(C5="01","John",
IF(C5="02","Peter",
IF(C5="03","Jose",
IF(C5="04","Ronald",
IF(C5="05","JACK",
IF(C5="06","Rene",
IF(C5="08","Alex",
IF(C5="09","Rob",
IF(C5="11","Denis",
IF(C5="12","Junior"
))))))))))



"Bill Martin -- (Remove NOSPAM from addre" wrote:

Pepito Grillo wrote:


As you can see, I am just giving more values. Is there a limit for IF to be
used ?


Yes, there is a limit to the depth of an IF statement. For your problem
I wouldn't bother with an IF anyhow. Try the following:

[ ] = CHAR(CODE("A")-1+C5)

Good luck....

Bill