Nested if formula

[ocuhcs]

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(M414>L414,"On
Time",IF(R414>0,"Pending",IF(M414>L414,"Late",IF(M414<=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)

 

[ocuhcs]

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(M414>L414,"On
Time",IF(R414>0,"Pending",IF(M414>L414,"Late",IF(M414<=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

 

[John Bundy]

Its hard to say without the data, but one thing i do notice is that you use
the same formula twice
=IF(M414>L414,"On Time"
and
IF(M414>L414,"Late"

 

[ocuhcs]

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.

 

[Pete_UK]

Try this then:

=IF(R414>0,"Pending",IF(L414="","no data",IF(M414>L414,"On
Time",IF(OR(M414<L414,M414<=TODAY()),"Late"))))

Change "no data" to something more suitable.

Hope this helps.

Pete