Thread
:
IF Function Does Not Work With Cell Reference
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Toppers
Posts: n/a
IF Function Does Not Work With Cell Reference
Works OK for me (XL2003)
"Ardus Petus" wrote:
Works by me (Excel 2000 - Win XP Pro)
HTH
--
AP
"Gary" a écrit dans le message de news:
...
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