onesidered,

How did you ever get so good at this Bernie? Wow...

Practice! ;-)

How about:

=IF(AND(C5<"",C5=3),"Suspended Player","Not more than 2 within last 5 weeks")

--
HTH,
Bernie
MS Excel MVP


"onesidered" wrote in message
...


All of the cells with a value of "" are now considered "suspended
players" instead of "Past 5 weeks"

We are almost there... thanx again. Who knew that excel was such a
powerful tool?


--
onesidered
------------------------------------------------------------------------
onesidered's Profile: http://www.excelforum.com/member.php...o&userid=25977
View this thread: http://www.excelforum.com/showthread...hreadid=393435