Posted to microsoft.public.excel.misc

Secret Squirrel Secret Squirrel is offline

external usenet poster

Posts: 172

If Statement

Perfect! Thanks!

"AKphidelt" wrote:

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.

"Secret Squirrel" wrote:

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If statement	rexmann	Excel Discussion (Misc queries)	2	December 13th 06 04:16 PM
appending and IF statement to an existing IF statement	spence	Excel Worksheet Functions	1	February 28th 06 11:00 PM
Help With If Statement	AceWebmaster	Excel Worksheet Functions	4	January 31st 06 03:35 AM
If statement and Isblank statement	Rodney C.	Excel Worksheet Functions	0	January 18th 05 08:39 PM
Help please, IF statement/SUMIF statement	Brad_A	Excel Worksheet Functions	23	January 11th 05 02:24 PM

All times are GMT +1. The time now is 10:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us