If invoice date is OTD then OT else Late and if OTD is blank then OT

Question

I am getting an error message. I am trying to do 2 statements in one. 

If Invoice Date is <= OTD Date + 1 day then OT else Late and of OTD Date is blank then OT 

Line OTD =

IF(

OR(IF(

Shipments_Data[Invoice Date] <= Shipments_Data[Sales Ord Ln OTD Date]+1, "OT", "Late"),

IF(

AND( Shipments_Data[Sales Ord Ln OTD Date] = blank, "OT"

)

))))

Thanks

Comments

Hello @ lcallicutt ,

Can you please provide more information about what error you are getting and what you are trying to do?