See the solution below
Case Checks a given expression against a series of values. If the expression is equal to a value, returns the corresponding result. If it is not equal to any values, it returns the else _result IF Determines if expressions are true or false. Returns a given value if true and another value if false