I don't understand.... Does my reply not make sense to you?

Question 1 - place this formula in every A1 cell:
=IF(B1>0,"Unassigned","")

Questin 2 - Place this formula in every C cell:
=IF(A5&B5="",D4,0)

That should give you the results that you are looking for.

--
"...I''m just a simple man, trying to make my way in the universe..."


"flyingby" wrote:

>
> ..................
>
>
> --
> flyingby
> ------------------------------------------------------------------------
> flyingby's Profile: http://www.excelforum.com/member.php...o&userid=27844
> View this thread: http://www.excelforum.com/showthread...hreadid=473523
>
>