| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement Problem
are you using quotes?
=if(a1="word","xyz","") (if it's not "word" cell is empty) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm having a really strange problem with 3 if statements. | Excel Worksheet Functions | |||
| If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
| Fundamental problem with IF statement | Excel Worksheet Functions | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
