I'm a relatively new user with Excel 2007, literally started working with the program about a week ago.

I'm attempting to create a function that will generate a unique value if a range of cell values meet the requirement.

Formula for L2 [=SUM(D2:K2)] is what I have so far.

If the cell values for D2:K2 are all "YES", how can I get the value for L2 to display "FMC"?

Sorry for the noob question, any help is much appreciated