Help with an IF Formula

D

Debbie

I am trying to get a formula to put in the cell "New Staff" if the
date is >12/31/09 but blank if false. This is the formula I am using.
Can you maybe tell me what I am doing wrong?

=IF(I6>"12/31/2009","NEW STAFF","")

I6 is a lookup formula putting the hire date in I6 cell.
The lookup formula is:

=IF(ISERROR(VLOOKUP($A6,'2010'!$A$1:$W
$314,5,FALSE)),"",VLOOKUP($A6,'2010'!$A$1:$W$314,5,FALSE))

Hope this all makes sense.

Thanks in advance.

Debbie
 
D

Don Guillett Excel MVP

I am trying to get a formula to put in the cell "New Staff" if the
date is >12/31/09 but blank if false. This is the formula I am using.
Can you maybe tell me what I am doing wrong?

=IF(I6>"12/31/2009","NEW STAFF","")

I6 is a lookup formula putting the hire date in I6 cell.
The lookup formula is:

=IF(ISERROR(VLOOKUP($A6,'2010'!$A$1:$W
$314,5,FALSE)),"",VLOOKUP($A6,'2010'!$A$1:$W$314,5,FALSE))

Hope this all makes sense.

Thanks in advance.

Debbie

=IF(I6>DATEVALUE("12/31/2009"),"NEW STAFF","")
 
J

Jim Cone

First make sure that the I6 cell is formatted as a Date.
-then-

Put the "12/31/2009" date (without the quote marks) in another cell and reference the cell...
=IF(I6>B1,"NEW STAFF","")
-or use-
=IF(I6>DATEVALUE("12/31/2009"),"NEW STAFF","")
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(sorting add-in)

..
..
..

"Debbie" <[email protected]>
wrote in message
I am trying to get a formula to put in the cell "New Staff" if the
date is >12/31/09 but blank if false. This is the formula I am using.
Can you maybe tell me what I am doing wrong?

=IF(I6>"12/31/2009","NEW STAFF","")

I6 is a lookup formula putting the hire date in I6 cell.
The lookup formula is:

=IF(ISERROR(VLOOKUP($A6,'2010'!$A$1:$W
$314,5,FALSE)),"",VLOOKUP($A6,'2010'!$A$1:$W$314,5,FALSE))

Hope this all makes sense.

Thanks in advance.

Debbie
 
P

Pete_UK

You could also try this:

=IF(I6>--"12/31/2009","NEW STAFF","")

as long as the date is in the format you normally use on your PC. The
double minus converts text into a numeric value.

Hope this helps.

Pete
 
D

Dave Peterson

One more:

=if(i6>date(2009,12,31), ...

I'm always afraid of using datevalue and strings. I'm not sure how excel (and
different locales) will treat: 01/02/03

January 2, 2003
February 3, 2001
or what???

I know how =date() will work.
 
D

Debbie

First make sure that the I6 cell is formatted as a Date.
-then-

Put the "12/31/2009" date (without the quote marks) in another cell and reference the cell...
=IF(I6>B1,"NEW STAFF","")
-or use-
=IF(I6>DATEVALUE("12/31/2009"),"NEW STAFF","")
--
Jim Cone
Portland, Oregon  USAhttp://www.contextures.com/excel-sort-addin.html
(sorting add-in)

.
.
.

"Debbie" <[email protected]>
wrote in messageI am trying to get a formula to put in the cell "New Staff" if the
date is >12/31/09 but blank if false. This is the formula I am using.
Can you maybe tell me what I am doing wrong?

=IF(I6>"12/31/2009","NEW STAFF","")

I6 is a lookup formula putting the hire date in I6 cell.
The lookup formula is:

=IF(ISERROR(VLOOKUP($A6,'2010'!$A$1:$W
$314,5,FALSE)),"",VLOOKUP($A6,'2010'!$A$1:$W$314,5,FALSE))

Hope this all makes sense.

Thanks in advance.

Debbie


Thanks, this worked perfect. You guys are awesome.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top