Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |