"ocuhcs" wrote:

The objective is to report the delivery status of open orders and to report
on performance of meeting milestones .

The formula I am attempting to use is:
=IF(M414L414,"On
Time",IF(R4140,"Pending",IF(M414L414,"Late",IF(M 414<=TODAY(),"Late"))))

Column M = estimated delivery date
Column L = actual delivery date (not always populated)
Column R = Outstanding balance (if = to 0, then column L is populated)

The prolem I am having is that it only returns 2 of the requested results