Simple SUM function Question

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

Hi,

As per my experience with Excel, nothing is a Noob if you learn to grow you will grow.

Please find the sample sheet for the result.



Thanks!
Moinuddin Shaikh

If you like my Response:
1. Show appreciation to those who have helped you by clicking "* Add Reputation" below their posts.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Appreciate someone towards their career path is better than saying Thanks!
-Moin

Excellent, it worked perfectly.

I'm extremely impressed by the response time, thanks for the help!

You're Welcome Larkin.


Thanks!
Moinuddin Shaikh

If you like my Response:
1. Show appreciation to those who have helped you by clicking "* Add Reputation" below their posts.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Appreciate someone towards their career path is better than saying Thanks!
-Moin