Okay!

Firstly thanks for providing such a great site. There's a lot of knowledge here. Im very new to using excel, so I've used this site a lot to figure stuff out, but this is the first time I havent been able to find an answer. I'm sorry if this question has already been answered on another thread, I looked but I couldn't find anything. If it is on another thread, before you just refer me there can you check to see if its an extremely similar scenario, because like I said I'm new, and I may not be able to apply the concept to my personal formula.

Okay, so I simplified my example, but basically what we have here is one cell that I need to reflect 4 cells of data. In the four cells referenced, if the value is greater than or equal to a specific limit, I need a letter identifier to be placed in the one cell. So if the limit is reached in the first 2 cells, the one cell would say, "T, W". I have it figured out for 3 sources of data, but when I try to run 4 sources I reach my limit on the total number of nester IF's per formula. I'm using 2007, and while I realize there is a lot of data about bypassing the number of nested IF's I cant figure it out still. I also don't want to get into the VB scripting side. I want to handle all of my business in that cell. Here is what it looks like.


EXCEL.png


Please break it down as simply as you can make it. I'm not that smart. Thanks for any help guys, I really appreciate it.

Kyle