Logical formula problem
 

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

Logical formula problem
 

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