Use of a Wildcard in A VBA Formula

[Ark68]

I have this line of code ...

.Range("D1").Formula = "=if(C1="""",0,if(C1=""OFF*"",0, if(c1=""STAT"",7.5,(C1-B1)*24-0.5)))"

If worked fine when I was simply comparing for the term "OFF", but I have since needed to adapt it for anything beginning with "OFF". I assume a wildcard '*' will not work in this situation.

What must I change to include any term beginning with "OFF" or better yet, change the forumula to recognize null values ("") or any text values?

 

[Norie]

You could use LEFT to check the first 3 characters.

.Range("D1").Formula = "=if(C1="""",0,if(LEFT(C1,3)=""OFF*"",0, if(c1=""STAT"",7.5,(C1-B1)*24-0.5)))"

 

[Ark68]

Thank you Norie!