Client wants to exclude certain departments from their financial report and the departments are not sequential. I am trying to exclude them using a formula in Column B.
(ACSEGVAL02 != "110") OR (ACSEGVAL02 != "200")
It seems that FR does not like the OR condition as I can use one value and FR is okay. When I want to add more than 1 value it gives me an error. Is this not possible?
Thanks
Terry