IF Expression Help
SummaryThe IF Expression is not returning the else value I'm inputting
I'm trying to write an IF expression but cannot return a proper else value. The following is my formula:
IF ([EMPL|CUSTOM_1321] == "Rosemount" or "Norpac" or "Septre" or "PIC" or "Farris") [Spartan Acquired Years] else 0
I'm trying to show if the above companies are in a cell I want the value to remain else I want 0 to display. Attached (in a Word document) is the Excel Formula and Report Output.