I should add that I would simply use the IF function but that only deals with 2 scenarios. In my case, I have 3 scenarios.