Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical test on linked data
My 2007 spreadsheet has a link to a CSV file. It brings the entire CSV into
the spreadsheet. I wanted to create a new column outside of the linked region that tested the condition of one cell and returned a result. Unfortunately it doesn't return the result but displays the test function itself. So in the cell I now get =if(Table_owssvr_13[[#This Row],[Status]]="Completed",10,if(Table_owssvr_13[[#This Row],[Status]]="To Be Created",3,6)) instead of the answer to the test. What am I missing here? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical test on linked data
I don't understand your syntax.
Where you've got Table_owssvr_13[[#This Row],[Status]] there should be a reference to a cell. I don't know 2007, but that doesn't look like the sort of cell reference I'm used to seeing in Excel 2003. If in the formula bar you type =, then click in the cell to which you are referring, what reference do you see after the = in the formula bar. -- David Biddulph "Humphrey" wrote in message ... My 2007 spreadsheet has a link to a CSV file. It brings the entire CSV into the spreadsheet. I wanted to create a new column outside of the linked region that tested the condition of one cell and returned a result. Unfortunately it doesn't return the result but displays the test function itself. So in the cell I now get =if(Table_owssvr_13[[#This Row],[Status]]="Completed",10,if(Table_owssvr_13[[#This Row],[Status]]="To Be Created",3,6)) instead of the answer to the test. What am I missing here? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical test on linked data
This is the new way Excel refers to cells within a pivot table. It's a
relative reference. I know it looks weird but thats the way it comes out when I create the function using my 15 years of using Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use 'CONTAINS' in an IF Logical Test? | Excel Worksheet Functions | |||
logical test | Excel Worksheet Functions | |||
logical test | Excel Worksheet Functions | |||
Logical Test | Excel Worksheet Functions | |||
Logical test | Excel Discussion (Misc queries) |