If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
putting a date in an if statement
When i write an if statement taht says this =IF(J26/1/2010,"N/A",J2),
it always comes up false. How do make it see the date? |
#2
|
|||
|
|||
putting a date in an if statement
=IF(J26/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(J2A1,"N/A",J2) Or, use the DATE function: =IF(J2DATE(2010,6,1),"N/A",J2) -- Biff Microsoft Excel MVP "pat67" wrote in message ... When i write an if statement taht says this =IF(J26/1/2010,"N/A",J2), it always comes up false. How do make it see the date? |
#3
|
|||
|
|||
putting a date in an if statement
On May 21, 2:04*pm, "T. Valko" wrote:
=IF(J26/1/2010,"N/A",J2) Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010. |
#4
|
|||
|
|||
putting a date in an if statement
On May 21, 2:04*pm, "T. Valko" wrote:
=IF(J26/1/2010,"N/A",J2) Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010. |
#5
|
|||
|
|||
putting a date in an if statement
Or you can put it as =IF(J2DATEVALUE("6/1/2010"),"N/A",J2)
I would be careful with that due to international settings. In the US, "6/1/2010" means 1-June-2010, but in Europe it means 6-January-2010. I would recommend that you use the DATE function to unambiguously get a date. E.g., DATE(2010,6,1) Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Fri, 21 May 2010 12:33:34 -0700 (PDT), jayray wrote: On May 21, 2:04*pm, "T. Valko" wrote: =IF(J26/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(J2A1,"N/A",J2) Or, use the DATE function: =IF(J2DATE(2010,6,1),"N/A",J2) -- Biff Microsoft Excel MVP "pat67" wrote in message ... When i write an if statement taht says this =IF(J26/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(J2DATEVALUE("6/1/2010"),"N/A",J2) |
#6
|
|||
|
|||
putting a date in an if statement
You're welcome!
-- Biff Microsoft Excel MVP "pat67" wrote in message ... On May 21, 2:04 pm, "T. Valko" wrote: =IF(J26/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(J2A1,"N/A",J2) Or, use the DATE function: =IF(J2DATE(2010,6,1),"N/A",J2) -- Biff Microsoft Excel MVP "pat67" wrote in message ... When i write an if statement taht says this =IF(J26/1/2010,"N/A",J2), it always comes up false. How do make it see the date?- Hide quoted text - - Show quoted text - thanks |
Thread Tools | |
Display Modes | |
|
|