View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pam D in Indy Pam D in Indy is offline
external usenet poster
 
Posts: 1
Default Use of dates in conditional and AND formulas

I'm not getting good values when I use dates in conditional or AND formulas.
Example: =if(A11/1/2004),1,0)
Example: =IF(AND(A11/1/2004,A1<1/1/2007),1,0)

Everything comes back either true or false, but not true to case.