Hi,
Thanks for your reply.
I want to enter the formula in D5
Could you help me with this please ?
Thanks again.
"Pepito Grillo" wrote:
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
|