Re: FORMULA NEEDED

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <Angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B79D5B58-2797-43AE-A860-3937B4799B30@xxxxxxxxxxxxxxxx
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.


.