Posted to microsoft.public.excel.worksheet.functions

Humphrey

external usenet poster

Posts: 22

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I use 'CONTAINS' in an IF Logical Test?	MichaelRobert	Excel Worksheet Functions	3	April 2nd 23 08:11 PM
logical test	LisaD	Excel Worksheet Functions	3	August 8th 06 03:24 PM
logical test	Ron Coderre	Excel Worksheet Functions	0	August 7th 06 08:02 PM
Logical Test	Lance	Excel Worksheet Functions	1	March 16th 06 09:26 PM
Logical test	Sooraj	Excel Discussion (Misc queries)	2	January 25th 05 12:59 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us