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! |
If then Statement for Excel Columns
In E1 enter:
=IF(K1<DATEVALUE("1/8/2011"),"Old","New") and copy down |
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 |
Great!
Thanks, Zoio Quote:
|
All times are GMT +1. The time now is 08:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com