I have created a Calculated Column that combines 3 other columns. The Formula for that is
=[Crs Code]&[Crs Number]&": "&[Crs Title]
And this works.
Now I want to do the same thing, but only if certain conditions are true.
The result needs to be =[Crs Code]&[Crs Number]&": "&[Crs Title], but only if the column [Delivery Status]= Active OR Under Development OR Under Revision. If none of those conditions are true, then move on to the next item for processing.
I tried all of the Formulas below, but all give syntax errors probably because IF statements in calculated columns require a TRUE and FALSE response. But, I don't know what to enter for the negative response, if all I am looking for is a positive response.
=IF(OR([Delivery Status]='Active',[Delivery Status]='Under Development',[Delivery Status]='Under Revision',[Crs Code]&[Crs Number]&": "&[Crs Title],""))
=IF(OR([Delivery Status]='Active',[Delivery Status]='Under Development',[Delivery Status]='Under Revision',[Crs Code]&[Crs Number]&": "&[Crs Title]))
=IF(OR([Delivery Status]='Active',[Delivery Status]='Under Development',[Delivery Status]='Under Revision'),[Crs Code]&[Crs Number]&": "&[Crs Title])
=IF(([Delivery Status]='Active',OR([Delivery Status]='Under Development'),OR([Delivery Status]='Under Revision')),([Crs Code]&[Crs Number]&": "&[Crs Title])
=IF(OR([Delivery Status]='Active',OR([Delivery Status]='Under Development'),OR([Delivery Status]='Under Revision')),([Crs Code]&[Crs Number]&": "&[Crs Title])
=IF([Delivery Status]='Active'),[Crs Code]&[Crs Number]&": "&[Crs Title],=IF([Delivery Status]='Under Development'),[Crs Code]&[Crs Number]&": "&[Crs Title],=IF([Delivery Status]='Under Revision'),[Crs Code]&[Crs Number]&": "&[Crs Title]
=IF([Delivery Status]='Active',[Crs Code]&[Crs Number]&": "&[Crs Title],=IF([Delivery Status]='Under Development',[Crs Code]&[Crs Number]&": "&[Crs Title],=IF([Delivery Status]='Under Revision',[Crs Code]&[Crs Number]&": "&[Crs Title])))
=IF(OR([Delivery Status]="Active",[Delivery Status]="Under Development",[Delivery Status]="Under Revision"),[Crs Code]&[Crs Number]&": "&[Crs Title]," ")