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.