"Pepito Grillo" wrote in message
...
Hi,

I am having problems using IF in a formula.

This one works:

=
IF(C5="01","A",
IF(C5="02","B",
IF(C5="03","C",
IF(C5="04","D",
IF(C5="05","E",
IF(C5="06","F",
IF(C5="08","G",
IF(C5="09","H"
))))))))


This one does not work. I get an error message.

=
IF(C5="01","A",
IF(C5="02","B",
IF(C5="03","C",
IF(C5="04","D",
IF(C5="05","E",
IF(C5="06","F",
IF(C5="08","G",
IF(C5="09","H"
IF(C5="11","I",
IF(C5="12","J",
IF(C5="13","K",
IF(C5="14","L",
IF(C5="15","M",
IF(C5="16","N",
))))))))))))))


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

Thanks in advance for your help

You can't have more than 7 nested IF's in a cell. the LOOKUP function can be
used instead of the formula that gives you an error. Have a look at:
http://www.techonthenet.com/excel/formulas/lookup.htm

/Fredrik