Nested if formula

  • Thread starter Thread starter ocuhcs
  • Start date Start date
O

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 said:
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)
Click to expand...
The prolem I am having is that it only returns 2 of the requested results
 
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"
 
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.
 
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
 
Back
Top