Logical formula problem

I

irresistible007

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" fo
*-all three cells-* !!!

Where am i mistaking ?
 
B

Biff

Hi!

Get rid of some of the quotes:
B1= "=IF(A1>="TODAY()", "True", "False")"
Click to expand...

=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" <[email protected]>
wrote in message
 
Top