IF Function Does Not Work With Cell Reference

Posted to microsoft.public.excel.worksheet.functions

Gary

Posts: n/a

IF Function Does Not Work With Cell Reference

Say you have a "<" sign in cell A1

And cell B1 contains "=A1".

Now, if I use an IF function that says =IF(A1="<","Curly","Larry") I
get Curly.

But if the IF function references B1, I get Larry.

So it seems that EXCEL 2003 is not smart enough to know that the value
of B1 is actually "<".

How can I fix this so that when I reference Cell B1 I get Curly.

Thanks,

Gary

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
Copying a work sheet cell reference as relative not absolute?	Velson	Excel Discussion (Misc queries)	4	January 7th 06 01:46 PM
indirect function to reference cell on different sheet	Dolemite	Excel Worksheet Functions	2	August 19th 05 05:25 PM
How can I reference a cell as the criteria in a count if function.	RobA	Excel Discussion (Misc queries)	1	August 17th 05 06:41 PM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Using result from ADDRESS function as a cell reference itself	LShutzberg	Excel Worksheet Functions	3	December 12th 04 11:18 AM

All times are GMT +1. The time now is 10:36 PM.

Menu

About Us