excel formulas

Hi,

This probably a very simple one but is given me a headache.  Can someone please help me find what I am missing in this formula?

Is very easy but hard for me....lol    

I need column "L" to either display "FullBoard" or "HalfBoard" or "NA" if no criteria was met.  So the way it will look for fullboard is if column "K" has the word "LU", if it doesn't have the word LU then it should be Halfboard, and in case there is an error somewhere the I will like "NA" to be display as last resort.

I need the cell marked in yellow working.  I have attached the file.

Thanks,
Template-.xlsb
tech-gineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
Hi,

Maybe

=IFERROR(IF(FIND("LU",K7,1),"FullBoard",(IF(D7="New York-Campus Dormitory","HalfBoard"))),NA())

Regards
0
[ fanpages ]IT Services ConsultantCommented:
Alternatively, in case "LU" is at the beginning of a comma-separated list of values within cell [K7], or at the end of the list of values, or cell [K7] is just "LU" (without any other values listed):

=IF(ISBLANK(K7),"NA",IF(OR(K7="LU",IFERROR(FIND(",LU",K7),0),IFERROR(FIND("LU,",K7),0)),"FullBoard","HalfBoard"))
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
[ fanpages ]IT Services ConsultantCommented:
Your example workbook file updated with the formula above applied to all appropriate cells within column [L].

Also, extra "test" rows added.
Q-28511544.xlsb
0
MontoyaProcess Improvement MgrCommented:
I'm not sure what your criteria for error would be since we're simply saying:

If it has LU then do FullBoard,
If not, do HalfBoard
That will only return one or the other..
If you want to a third option, then we would have to test for a data type, perhaps...

In either case, this works:

=IFERROR(IF(ISNUMBER(SEARCH("LU",K2)),"FullBoard","HalfBoard"),"NA")
0
[ fanpages ]IT Services ConsultantCommented:
^ I specifically checked for ",LU" & "LU," in case any of the other text within column [K] contained those two characters.

For example,

"FIRST,CLUE,SECOND"
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.