Then.....

Try this:
=IF(COUNTIF(Q1,"*ok*"),"YES","something else")

or..
=IF(COUNTIF(Q1,"*ok*"),"YES","")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Angie" wrote in message
...
Sorry, I forget that Caps Lock is on.

No this isn't working. The cell contains the work "OK" along with other
phrases. THe cell value will not be "OK" This is where I meet my wall. I
have
tried formulas with
=IF(Q1 but I cannot use =IF(Q1=

"Ron Coderre" wrote:

Try this:

=IF(Q1="ok","YES","something else")
or...maybe...
=IF(Q1="ok","YES","")

Is that something you can work with?

Whenever you have issues constructing a formula you'll probably get an
answer from this forum faster than you can find the answer in Excel
Help.

(Also...messages in all capital letters indicate that you're shouting.)
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Angie" wrote in message
...
IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES"

iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING
FORMULAS?
iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I
WOULD
BE
FINE.