Need formula to say "Late" or "On time" if qty entered by end of Each Month

[LLOCKSLEY]

Hi Friends,

I needed a formula to add on to a column , if the product shipped Complete on the same month it should say "On time" if not "Late" if nothing has shipped and still has not passed October then it should be saying "0"


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]October ORDER[/TD]
[TD] OCT SHIPPED[/TD]
[TD]LATE /ON TIME[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]100[/TD]
[TD]On time[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]30[/TD]
[TD]Late[/TD]
[/TR]
</tbody>[/TABLE]

Need a formula if nothing shipped UNTIL 10/31/2015 then it should show late , if a Qty Ship matches Order Qty should say on time if it less than Qty it should say Late.

Any help would be great.

Thank you in advance

 

[AlanY]

try

Excel 2012
	A	B	C
1	October ORDER	OCT SHIPPED	LATE /ON TIME
2	100	100	On time
3	100	30	Late
Sheet1

Cell Formulas
Range	Formula
C2	=IF(B2=0,0,IF(B2))

 

[LLOCKSLEY]

try

Excel 2012

	A	B	C
October ORDER	OCT SHIPPED	LATE /ON TIME
On time
Late

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]30[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C2[/TH]
[TD="align: left"]=IF(B2=0,0,IF(B2<A2,"Late","On time"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much Alan, much appreciated, but is it possible if the date October30 is passed and moves to next month and there is no shipment entry made, can it be shown "Late" , or do I need to create another Column for the same.

Please advise

 

[AlanY]

you're welcome.
not clear of your last question, would you give an example as what needed?