Nested if formula
 

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)

Nested if formula
 

"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

Nested if formula
 

Its hard to say without the data, but one thing i do notice is that you use
the same formula twice
=IF(M414L414,"On Time"
and
IF(M414L414,"Late"
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"ocuhcs" wrote:



"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

Nested if formula
 

Thanks, I was using for both test when one should have been <. That solved
one problem, but now I see the problem I am having is that if column L has no
data then I get an improper result.

"John Bundy" wrote:

Its hard to say without the data, but one thing i do notice is that you use
the same formula twice
=IF(M414L414,"On Time"
and
IF(M414L414,"Late"
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"ocuhcs" wrote:



"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

Nested if formula
 

Try this then:

=IF(R4140,"Pending",IF(L414="","no data",IF(M414L414,"On
Time",IF(OR(M414<L414,M414<=TODAY()),"Late"))))

Change "no data" to something more suitable.

Hope this helps.

Pete

On Feb 22, 2:33*pm, ocuhcs wrote:
Thanks, I was using for both test when one should have been <. That solved
one problem, but now I see the problem I am having is that if column L has no
data then I get an improper result.



"John Bundy" wrote:
Its hard to say without the data, but one thing i do notice is that you use
the same formula twice
=IF(M414L414,"On Time"
and
IF(M414L414,"Late"
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"ocuhcs" wrote:

"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- Hide quoted text -

- Show quoted text -