Prev: How to retain part of formula's criteria as static
Next: How to have a cell auto resize the font to make text fit in cell?
From: T. Valko on 21 May 2010 21:25
You're welcome!

--
Biff
Microsoft Excel MVP


"pat67" <pbuscio(a)comcast.net> wrote in message
news:6fccbc55-6f3c-455d-a7a1-c39156790b41(a)q23g2000vba.googlegroups.com...
On May 21, 2:04 pm, "T. Valko" <biffinp...(a)comcast.net> 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<A1,"N/A",J2)
>
> Or, use the DATE function:
>
> =IF(J2<DATE(2010,6,1),"N/A",J2)
>
> --
> Biff
> Microsoft Excel MVP
>
> "pat67" <pbus...(a)comcast.net> 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


First  |  Prev  | 
Pages: 1 2
Prev: How to retain part of formula's criteria as static
Next: How to have a cell auto resize the font to make text fit in cell?