Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If then Statement for Excel Columns
Hello,
I'm not very proficient at Excel. Need some help. How would I go about making a if then statement for 2 rows. I would like something like this. "If dates in Column K is less than 01/08/2011 -- then Column E = Old else Column = New" I have a bunch of dated forms and if its older then 01/08/2011 I need it to post Old or New if its newer then 01/08/2011. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then Statement for Excel Columns
In E1 enter:
=IF(K1<DATEVALUE("1/8/2011"),"Old","New") and copy down |
#3
|
|||
|
|||
I have a bunch of dated forms and if its older then 01/08/2011 I need it to post Old or New if its newer then 01/08/2011.
_____ memory foam mattress | adjustable mattresses | memory pillow |
#4
|
|||
|
|||
Great!
Thanks, Zoio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you do an IF statement in Excel comparing three columns | Excel Worksheet Functions | |||
if statement using rows and columns | Excel Discussion (Misc queries) | |||
IF Statement using several columns | Excel Worksheet Functions | |||
Countif Statement for 2 columns | Excel Discussion (Misc queries) | |||
If statement using multi columns | Excel Worksheet Functions |