Hello, I have a calculated column: =IF([Due Date]="","N/A","Due: "&MONTH([Due Date])&"/"&DAY([Due Date])&"/"&YEAR([Due Date])) I have been trying to figure out how to include the following condition for the [Status], which I thought I could do with an OR statement as follows: =IF([Due Date]="" or [Status]="Completed","N/A","Due: "&MONTH([Due Date])&"/"&DAY([Due Date])&"/"&YEAR([Due Date])) If someone could please show me the proper syntax for how to include the [Status]="Completed" I would really appreciate it. Thanks, Bruce

You need to use the OR function like OR(Condition1,Condition2), so something like =IF(OR([Due Date] = "", [Status] = "Completed")) http://msdn.microsoft.com/en-us/library/bb862071.aspxcertdev.com

THANK YOU MR. CURRAN!