| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked Cells If Statement
I am trying to set up an If Statement so that if Cell A2 has an 11 inside of
it, whatever contents are in cell H2 will also appear in cell K2. This is the IF Statement that I have in cell K2, =IF(Sheet1!A2="11","H2",""), but in cell K2 the text H2 appears instead of the contents in cell H2. I understand why that's happening but I don't know how to fix it. Any thoughts? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Cells If Statement
Just remove the quotes from around "H2".
=IF(Sheet1!A2="11",H2,"") The quotes tell Excel to treat what is inside as literal text. HTH Elkar "Workbook" wrote: I am trying to set up an If Statement so that if Cell A2 has an 11 inside of it, whatever contents are in cell H2 will also appear in cell K2. This is the IF Statement that I have in cell K2, =IF(Sheet1!A2="11","H2",""), but in cell K2 the text H2 appears instead of the contents in cell H2. I understand why that's happening but I don't know how to fix it. Any thoughts? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Cells If Statement
Wow, it was right under my nose. Thanks Man, I appreciate you're help.
"Elkar" wrote: Just remove the quotes from around "H2". =IF(Sheet1!A2="11",H2,"") The quotes tell Excel to treat what is inside as literal text. HTH Elkar "Workbook" wrote: I am trying to set up an If Statement so that if Cell A2 has an 11 inside of it, whatever contents are in cell H2 will also appear in cell K2. This is the IF Statement that I have in cell K2, =IF(Sheet1!A2="11","H2",""), but in cell K2 the text H2 appears instead of the contents in cell H2. I understand why that's happening but I don't know how to fix it. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
| Linked Cells | Excel Discussion (Misc queries) | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
