Hello everybody:
I've been having a little problem with the if formula. This is my first time that i post in english so forgive me if i make to many gramatical mistakes.
well the thing is that i have data input with sales description and i want to write some especific words in one cell base on some key words in the description that is in other cell, for example
description
AF C PS 2 ITS Imp Tape VSM + 9840
and the formula is:
=IF(ISNUMBER(SEARCH("DOCUMENT",$F306)),"Mail",IF(ISNUMBER(SEARCH("MAIL",$F306)),"Mail",IF(ISNUMBER(SEARCH("VIDEO",$F306)),"VideoSur",IF(ISNUMBER(SEARCH("DCS",$F306)),"DCS",IF(ISNUMBER(FINDB("ESS",$F306)),"ESS",IF(ISNUMBER(SEARCH("ITS",$F306)),"IMP","Sales1"))))))
that will return the word IMP base on the product description above
for now i have three diferent formulas because the if statements are too many and i can nest more than 6 or 7 if statements in one formula.
So what i want is to find a way to be able to nest more than 7 if statements
hope you can help me i already check previous posts and i couldn't fine anything...
thanks..
Anala
I've been having a little problem with the if formula. This is my first time that i post in english so forgive me if i make to many gramatical mistakes.
well the thing is that i have data input with sales description and i want to write some especific words in one cell base on some key words in the description that is in other cell, for example
description
AF C PS 2 ITS Imp Tape VSM + 9840
and the formula is:
=IF(ISNUMBER(SEARCH("DOCUMENT",$F306)),"Mail",IF(ISNUMBER(SEARCH("MAIL",$F306)),"Mail",IF(ISNUMBER(SEARCH("VIDEO",$F306)),"VideoSur",IF(ISNUMBER(SEARCH("DCS",$F306)),"DCS",IF(ISNUMBER(FINDB("ESS",$F306)),"ESS",IF(ISNUMBER(SEARCH("ITS",$F306)),"IMP","Sales1"))))))
that will return the word IMP base on the product description above
for now i have three diferent formulas because the if statements are too many and i can nest more than 6 or 7 if statements in one formula.
So what i want is to find a way to be able to nest more than 7 if statements
hope you can help me i already check previous posts and i couldn't fine anything...
thanks..
Anala