Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incremental formula problem | Excel Worksheet Functions | |||
IF formula problem | Excel Worksheet Functions | |||
Problem with Formula | Excel Worksheet Functions | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions |