IF statement starting with text - multiple criteria

[BHR]

I am trying to write a formula where if the first letter of a word starts with certain letters, then the formula would populate the cell with either "Economy" or "Other".

For example, if the text starts with the letter "S" or "U" or" "E" then populate with "Economy", if not then "Other".

I've only been able to figure out this much...I can't figure out the rest.

=IF(LEFT(E317262,1)="S","Economy","Other")

Thanks so much for your help.

[jeffreybrown]

One way...

=IF(OR(LEFT(A1,1)={"S","U","E"}),"Economy","Other")

[BHR]

Thank you! You've saved me gobs of time. I'm going to post one formula I can't figure out that's been crippling me.

[jeffreybrown]

You are very welcome, glad it worked out for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save