If Statement Problem
 

I am having trouble with "if" and "then" working. Or maybe I'm just using the
wrong formula to do what I want in Excel.
What I'm trying to accomplish is, If a specific column says a specific word,
then five this cell ( which is in a different column) "xyz" value. I can't
get it to work with a word. I can get it to work with saying if this number
is typed in, then give the other cell this value. HELP!

If Statement Problem
 

If you post your actual formula, we'll have a better chance of identifying
your problem.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Brandy" wrote:

I am having trouble with "if" and "then" working. Or maybe I'm just using the
wrong formula to do what I want in Excel.
What I'm trying to accomplish is, If a specific column says a specific word,
then five this cell ( which is in a different column) "xyz" value. I can't
get it to work with a word. I can get it to work with saying if this number
is typed in, then give the other cell this value. HELP!

If Statement Problem
 

are you using quotes?

=if(a1="word","xyz","")

(if it's not "word" cell is empty)