I need to construct a multiple OR statement that looks at the first 5
characters of a cell (G16) and if it is Table, Day-T or Eveni, then
expression 1, otherwise expression 2.

Having asked a colleague, they have come up with:-

=IF(OR(LEFT(G16,5)="Table€�,LEFT(G16,5)="Day-T€�,
LEFT(G16,5)="Eveni),expression 1,expression 2)

Is there an easier way to write the above?

Any assistance offered would be welcome.

Regards

PM