check if cell is blank or start with**

Dear all,

i search the forum for my question but can't find an answer.
What is the formula for checking a cell if its blank or start with the tect "SM"
In case of blank or start with "SM" the rewsult should be blank otherwise the result should be the text "project"

Thank you very much in advance for your feedback

BR Suske

Try this:

=IF(OR(A1="";LEFT(A1;2)="SM");"";"project")

I've put semicolons in the formula as I expect that you use them - if not, replace them with commas.

Hope this helps.

Pete

Try this:

=IF(OR(A1="";LEFT(A1;2)="SM");"";"project")

I've put semicolons in the formula as I expect that you use them - if not, replace them with commas.

Hope this helps.

Pete

Yes Thank you Pete it works, Super

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete