Hi all, thanks for responding- What i am trying to do is: I have several
numerical columns of data which need replacing with corresponding text. Eg
Country code 1= India. The problem is, some of the columns have over 200
different codes, so an if statement doesnt work in this instance. Is there
anything you can suggest?

Thanks for your help

"Don Guillett" wrote:

if(your7) + if
but it would be better to use a lookup table or choose or something else.
What is your formula?
--
Don Guillett
SalesAid Software

"smithers2002" wrote in message
...
Excel 2003: Should be able to use more than 7 IF statements in one
arguement-
I constantly need to use these, but can only enter 7 arguements. Is there
a
way of entering more arguements as part of the same formula?