If "text" is in cell L151 then "POSTED" (1 Viewer)

[xpander]

Can you use INSTR or something in an Access query to make it so that, for example, If "text" is in cell L151 then "POSTED" else "Not POSTED" ?

 

[theDBguy]

Hi. Welcome to AWF!

I think you can as well as trying to use the LIKE operator. Give it a shot and let us know how it goes.

 

[xpander]

=IF(INSTR(1,[L151],"text")<>0, "POSTED","Not POSTED")

 

[theDBguy]

=IF(INSTR(1,[L151],"text")<>0, "POSTED","Not POSTED")

In a query, you wouldn't use the equals sign and you would use the IIF() function and not IF().

 

[theDBguy]

In a query, you wouldn't use the equals sign and you would use the IIF() function and not IF().

You are using Access and not Excel, right?

 

[xpander]

=IF(L151 Like 'text',"POSTED") got me nowhere.

 

[xpander]

You are using Access and not Excel, right?

OH, Sorry. I AM in Excel. Ergh

 

[theDBguy]

OH, Sorry. I AM in Excel. Ergh

No worries. We can move it.

 

[KitaYama]

Can you use INSTR or something in an Access query to make it so that, for example, If "text" is in cell L151 then "POSTED" else "Not POSTED" ?

Excel has COUNTIF instead of InStr.

=IF(COUNTIF(L151,"*Text*"),"Posted","Not Posted")

 

[Gasman]

Crossposted https://www.accessforums.net/showthread.php?t=89554