From: pat67 on 21 May 2010 13:48 When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2), it always comes up false. How do make it see the date? From: T. Valko on 21 May 2010 14:04 >=IF(J2<6/1/2010,"N/A",J2) Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010. The best way to do this is to use a cell to hold the date: A1 = 6/1/2010 Then just refer to that cell: =IF(J2 wrote in message news:0002e7c8-77dd-4995-b59e-ae533583e7f7(a)o39g2000vbd.googlegroups.com...> When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2), > it always comes up false. How do make it see the date? From: pat67 on 21 May 2010 15:28 On May 21, 2:04 pm, "T. Valko" wrote:> >=IF(J2<6/1/2010,"N/A",J2) > > Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010. > > The best way to do this is to use a cell to hold the date: > > A1 = 6/1/2010 > > Then just refer to that cell: > > =IF(J2 > Or, use the DATE function: > > =IF(J2 > -- > Biff > Microsoft Excel MVP > > "pat67" wrote in message > > news:0002e7c8-77dd-4995-b59e-ae533583e7f7(a)o39g2000vbd.googlegroups.com... > > > > > When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2), > > it always comes up false. How do make it see the date?- Hide quoted text - > > - Show quoted text - thanks From: jayray on 21 May 2010 15:33 On May 21, 2:04 pm, "T. Valko" wrote:> >=IF(J2<6/1/2010,"N/A",J2) > > Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010. > > The best way to do this is to use a cell to hold the date: > > A1 = 6/1/2010 > > Then just refer to that cell: > > =IF(J2 > Or, use the DATE function: > > =IF(J2 > -- > Biff > Microsoft Excel MVP > > "pat67" wrote in message > > news:0002e7c8-77dd-4995-b59e-ae533583e7f7(a)o39g2000vbd.googlegroups.com... > > > > > When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2), > > it always comes up false. How do make it see the date?- Hide quoted text - > > - Show quoted text - Or you can put it as =IF(J2Or you can put it as =IF(J2 wrote: >On May 21, 2:04�pm, "T. Valko" wrote: >> >=IF(J2<6/1/2010,"N/A",J2) >> >> Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010. >> >> The best way to do this is to use a cell to hold the date: >> >> A1 = 6/1/2010 >> >> Then just refer to that cell: >> >> =IF(J2> >> Or, use the DATE function: >> >> =IF(J2> >> -- >> Biff >> Microsoft Excel MVP >> >> "pat67" wrote in message >> >> news:0002e7c8-77dd-4995-b59e-ae533583e7f7(a)o39g2000vbd.googlegroups.com... >> >> >> >> > When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2), >> > it always comes up false. How do make it see the date?- Hide quoted text - >> >> - Show quoted text - > >Or you can put it as =IF(J2