Hi!
Get rid of some of the quotes:
B1= "=IF(A1="TODAY()", "True", "False")"
=IF(A1=TODAY(),"True", "False")
That can also be expressed as:
=A1=TODAY()
It will also return TRUE or FALSE but as Boolean values where the IF formula
returns True or False as TEXT values.
Biff
"irresistible007"
wrote in message
...
Dear reader,
I know i am mistaking but the problem is that i cant find my mistake.
I am actually practising IF formula... below is the situation
DATA:
A1= 11/16/2005
A2= 11/17/2005
A3= 11/18/2005
B1= "=IF(A1="TODAY()", "True", "False")"
B2= "=IF(A2="TODAY()", "True", "False")"
B3= "=IF(A3="TODAY()", "True", "False")"
Well today is actually 17th Nov-05 but still I am getting "False" for
*-all three cells-* !!!
Where am i mistaking ??
--
irresistible007
------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2287876