Not sure what to title this....

[Drdave1958]

227G01 Tracking_newdates_111703.xls
	A	B	C	D	E	F
1		JobNumber	P14	P15	NeedMat'lby	ShipDate
2	PiecesinInventory		4	0
3		800914	X	20-Feb	20-Feb	05-Mar
4		800916	X	24-Feb	24-Feb	09-Mar
5		800917	X	05-Mar	05-Mar	19-Mar
6		800918	X	12-Mar	12-Mar	26-Mar
7		800919	18-Mar	18-Mar	18-Mar	01-Apr
8		800920	28-Mar	28-Mar	28-Mar	11-Apr
9		800921	04-Apr	04-Apr	04-Apr	18-Apr
10		800922	11-Apr	11-Apr	11-Apr	25-Apr
11		800923	18-Apr	18-Apr	18-Apr	02-May
12		800924	25-Apr	25-Apr	25-Apr	09-May
13		800925	02-May	02-May	02-May	16-May
Test

The above sheet shows a small portion of a huge tracking sheet for an assembly. Row 2 shows the quantity of stock in inventory, of individual pieces (P14 & P15) that make up the assy. This is a number I will manually key in. I also will key in the ship date in column F, which drives column E. What I want to happen (I'm not sure if this is possible), If the number I key into D2 is< 1, (zero or blank will work), then D3:D13 will display the date in column E.
The second criteria is the more tricky one. If I key in a number > 0, (like 4 in my example) then that number of X"s will appear in the rows C3:C13. At the same time if I change the 4 back to a zero, then the X"s will disappear and the date driven by column E will re-appear. NOTE: Columns C & D are the same but show the two different results that are required.
Please advise if more clarity is needed.

Thanks in advance,
-Dave-

 

[Aladin Akyurek]

In C3 enter & copy down:

=IF(N($C$2)*(ROW()-ROW($C$3)+1<=$C$2),"x",E3)

 

[Drdave1958]

Thanks Aladin, works perfect!

-Dave-