If Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I write an "IF" statement to find a cell that has the letter "G" in it.

Example:

HW-G12345

The letter "G" won't always be in the exact spot in each cell.

Any help would be greatly appreciated.
 
Try this

=IF(ISERROR(FIND("G",A1,1)),"no","yes")

Change A1 to whatever cell the value is that you want to find G in.
 
What exactly do you mean by find?
Do you want the cell address?
Do you want data returned from an adjoining column on the same row?

And where exactly are you searching?
A column?
An array/
The entire sheet?

And will there be duplicates, where you'll want more then a single return?

How about more info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distinguish Letters vs. Numbers in an IF Statement 4
If Statements - Pick up Alpha Characters 8
If statement HELP! 7
How to type each letter of the alphabet automatically in a specific color in Word? 0
If statement with dates 0
IF Statement Variable 3
If Statement 2
How do I find data excluded from a list in excel? 2

Back
Top